DAX : Extract text between delimiter

[Anonymous]

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

[Ahmedx]

and try this

Text.Split([DATA],"/"){3}

[Ahmedx · Accepted solution]

pls try this

[Anonymous]

Thank you for your help. 

[Ahmedx]

I'm glad to help you!