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
Nesta página do site você pode assistir ao vídeo on-line Find and Remove Last Occurrence from a String using Power BI DAX duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Dhruvin Shah 03 Novembro 2020, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 4,614 vezes e gostou 35 espectadores. Boa visualização!
