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.
I know there is a way to do this in Power Query but I am just wondering if there is an option in DAX primarily in a calculated column.
Currently my data looks like this . Thanks in advance!
Code | Expected result |
BSA06 Test North - 19C | 19C |
ASA01 Test-ABC - 32B | 32B |
ESA05 NotReal – 15 | 15 |
TSA01 Awesome Rural - Prov | Prov |
try to write like this
Text.Trim(Text.Range(
[Code],
Text.PositionOfAny(
[Code],
{Character.FromNumber(8211), Character.FromNumber(45)},
RelativePosition.FromEnd
)
+ 1
))
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhkhamWLt92LapWi6?e=vnoowN
Hi,
Try this calculated column formula
Column = mid(Data[Code],SEARCH(" - ",Data[Code],,0)+3,50)
It does not work for the third one, because that symbol is not a -.
Please check this post and solution https://community.powerbi.com/t5/Desktop/Splitting-Text-on-multiple-delimiters-with-DAX/m-p/2480035
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |