Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
vnqt
Helper V
Helper V

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

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

4 REPLIES 4
Ahmedx
Super User
Super User

and try this

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

Screenshot_2.png

 

Ahmedx
Super User
Super User

pls try this

Screenshot_1.png

Thank you for your help. 

I'm glad to help you!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.