Extracting Characters from Power BI Strings using DAX Text Functions | LEFT/ RIGHT/ SEARCH & More!

In this quick video, we'll be using the DAX LEFT, RIGHT, MID, SEARCH & LEN functions to simply and dynamically extract characters from Asset IDs. These functions are transferrable and can be used for all varieties of character strings.

This can also be achieved using Power Query, but sometimes DAX is your only option and therefore, a fundamental skill to have in your Power BI toolkit!

🤝 Visit my Website:

🤝 Connect with me on LinkedIn:

Please Like, Subscribe, Comment & Share if you enjoy!

[Dhamdard]

These little tricks proved very helpful to me. I work with a set of data with varied sizes of event names but each event has a common string at the end of the event name. These tricks helped me use the left and search together to eliminate the extra string from the event names. Thank you for sharing your knowledge.

[justsayjoe]

What if you have multiple delimiters in the text string? I have a text string column with 10 underscores that I want to pivot out each of the 11 pieces of text from those ten delimiters. I cannot use power query because it's a calculated table, so I need the right DAX code to peel out each text string from 10 delimiters.

[JJ-rfrb]

What about the extraction of some sets of characters that are in different positions? I'm using CONTAINSSTRINGEXACT but having problems with the boolean results