Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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))
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
@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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |