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
On this page of the site you can watch the video online Find and Remove Last Occurrence from a String using Power BI DAX with a duration of hours minute second in good quality, which was uploaded by the user Dhruvin Shah 03 November 2020, share the link with friends and acquaintances, this video has already been watched 4,614 times on youtube and it was liked by 35 viewers. Enjoy your viewing!
