Find and Remove Last Occurrence from a String using Power BI DAX
During this session, we will learn how we can find and remove last occurrence from a string using Power BI DAX. This is equivalent to Text Before Delimitator property in Power Query. In Power Query we can get before specific occurrence from string very easily. But how we can achieve the same using Power BI DAX? This video provides a solution for the same.
We have taken an example of URL. I want to remove the last path after "/" from the entire URL string. So, how can I achieve this with the help of DAX?
We want to split URL string using "/" and remove its last occurrence and we want to achieve everything in DAX.
So, we need alternative of Split and Text Before Delimitator alternative in DAX.
Chapters:
00:00 Introduction
00:12 Requirement
01:19 Logic
02:10 Find Total Length for String
02:48 Find how many slashes are there in string?
03:50 Remove values after last "/"
04:03 Find out position of last occurrence from string
06:58 End
#PowerBI #DAX #PowerBIDAX #PowerBIDesktop #PowerPlatform #Microsoft #PowerBIWithDhruvin