Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |