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
En esta página del sitio puede ver el video en línea Find and Remove Last Occurrence from a String using Power BI DAX de Duración hora minuto segunda en buena calidad , que subió el usuario Dhruvin Shah 03 noviembre 2020, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 4,614 veces y le gustó 35 a los espectadores. Disfruta viendo!
