Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
21 | |
20 | |
15 | |
10 | |
7 |
User | Count |
---|---|
29 | |
28 | |
12 | |
12 | |
12 |