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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
PBI_newuser
Post Prodigy
Post Prodigy

DAX: how to extract text after delimiter

Hi, how to create column to extract text after delimiter.

Data: 

8/12

2/1

3/4

Expected output:

12

1

4

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@PBI_newuser , In power query

new column Text.AfterDelimiter([Column], "/")

 

https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter

 

in DAX

new column = right([Column], len([column]) - search("/",[Column],,0))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

2 REPLIES 2
LaRy
New Member

Hi, is it possible to extract columns from a situation like the one below?

 

Data: 

Numer nadania: 647400836356416129470819, Kod: INP_P1_PACZKOMATY, Identyfikator zamowienia: 55bf2550-a549-11ee-bda1-4bfbe848971d, Szczegy: Allegro Paczkomaty InPost; Order value = 459.00 PLN - w ramach Uslugi Allegro Smart

 

Numer nadania: 647400836307410122074978, Kod: INP_P1_PACZKOMATY, Identyfikator zamowienia: db2d1120-a54e-11ee-9699-ad9dc553161c, Szczegy: Allegro Paczkomaty InPost; Order value = 439.00 PLN - w ramach Uslugi Allegro Smart

 

Numer nadania: 647400446360467126849155, Kod: INP_P1_PACZKOMATY, Identyfikator zamowienia: 509d7fe0-a049-11ee-8480-632edde38ac0, Szczegy: Allegro Paczkomaty InPost; Order value = 51.57 PLN - w ramach Uslugi Allegro Smart

 

Expected output:

 

55bf2550-a549-11ee-bda1-4bfbe848971d

db2d1120-a54e-11ee-9699-ad9dc553161c

509d7fe0-a049-11ee-8480-632edde38ac0

 

thank you

amitchandak
Super User
Super User

@PBI_newuser , In power query

new column Text.AfterDelimiter([Column], "/")

 

https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter

 

in DAX

new column = right([Column], len([column]) - search("/",[Column],,0))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.