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.
This is a followup from https://community.powerbi.com/t5/DAX-Commands-and-Tips/seaching-for-keywords-in-text-for-use-as-inde...
Why does this work?
but this doesnt?
Solved! Go to Solution.
Mystery solved. CONCATENATEX never returns blank. At the minimum it returns an empty string. So there seems to be a bug in DAX that allows the comparison of an empty string to BLANK() to be true.
Mystery solved. CONCATENATEX never returns blank. At the minimum it returns an empty string. So there seems to be a bug in DAX that allows the comparison of an empty string to BLANK() to be true.
@marcorusso I ran this in DAX studio. Is there a good explanation for this?
evaluate row(
"Test1",ISBLANK(""),
"Test2",""=BLANK()
)
Thank you Marco. Would be nice if the article could also mention the "==" operator.
Good suggestion, I just added an example of == in that article. Thanks!
Hi @lbendlin ,
https://www.youtube.com/watch?v=C26DQkb4hyY
Have a look at this video.
Regards,
Harsh Nathani
@harshnathani Thank you. I am not ashamed to admit that I was not aware of the equality operator ("==") being available in DAX. That makes more sense now. Single equal sign does a type transformation. Thanks again!
User | Count |
---|---|
57 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
116 | |
41 | |
40 | |
28 | |
22 |