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.
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!
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
48 | |
45 | |
19 | |
16 |