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
I have a formula I use a lot in my excel analysis, but I want to built into powerBi as a calculated column:
=iferror(MID(A1,FIND("TCN",A1),11),A1)
Can I create a DAX command which does the same?
Thanks
Kristoffer
Solved! Go to Solution.
=iferror(MID([colnum name],FIND("TCN",[colnum name]),11),[colnum name])
=iferror(MID([colnum name],FIND("TCN",[colnum name]),11),[colnum name])
Hah this was Simple! - was missing a minor thing - THANKS!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |