Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have this formula that works fine:
(find(",",'Enforcement%20Tracking'[Matter Name + Details],1,blank())-1)
It finds the position of the first comma and then subtracts one
And I have this formula that works fine:
Solved! Go to Solution.
Hey @jameskeuning ,
LEFT expects a numeric value, FIND returns BLANK (what is a not a numeric value) if you change the NOTFOUNDPARAMETER to a reasonable value it works as expected.
If you can not provide a reasonable value, then you have to check the return value of FIND and depending on the result you branch to the LEFT algorithm or something different like another BLANK()
DAX does not perfrom implicit type conversion, some people consider this great some don't.
Hopefully, this provedes you ideas of how to tackle your challenge.
Regards,
Tom
Hey @jameskeuning ,
LEFT expects a numeric value, FIND returns BLANK (what is a not a numeric value) if you change the NOTFOUNDPARAMETER to a reasonable value it works as expected.
If you can not provide a reasonable value, then you have to check the return value of FIND and depending on the result you branch to the LEFT algorithm or something different like another BLANK()
DAX does not perfrom implicit type conversion, some people consider this great some don't.
Hopefully, this provedes you ideas of how to tackle your challenge.
Regards,
Tom
Thanks Tom. I noticed that I get a -1 result if there is no comma in the field, so that gave me a hint as to the problem, and your response helped me connect the dots.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |