Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lbendlin
Super User
Super User

value = BLANK() versus ISBLANK(value)

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

 

 

View solution in original post

7 REPLIES 7
lbendlin
Super User
Super User

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors