Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX : Extract text between delimiter

Hi, 

 

I have column Location with multiple /. I would like to extract the Site between the delimiter : 

 

US/45395/UTAH/Salt Lake City A/Room C13

I would like to add a new column to extract Salt Lake City A from Location column.

 

I would like to translate the Power Query Text.BetweenDelimiters([Location], "/", "/", 2, 0) to DAX. 

 

 

Thank you in advance for your help.

TG

4 Replies