- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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))

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
10-22-2024 07:21 AM | |||
06-18-2024 07:41 AM | |||
07-06-2023 04:14 PM | |||
10-11-2024 02:09 PM | |||
07-09-2024 05:03 PM |
User | Count |
---|---|
85 | |
71 | |
63 | |
50 | |
29 |
User | Count |
---|---|
117 | |
102 | |
71 | |
64 | |
39 |