Forum Discussion
Solved
DAX Comparison operators
Hi, I am trying to compare a measure value with null("") through OR condition Ex:Measure = if(precreatedMeasure1 = "" || precreatedmeasure2 =0, "",sum(columndata)). There is no error in...
DAX uses BLANK() for database nulls.
You can try above code it will resolve your issue and you can also refer below article.
https://docs.microsoft.com/en-us/dax/blank-function-dax
DAX uses BLANK() for database nulls.
You can try above code it will resolve your issue and you can also refer below article.
https://docs.microsoft.com/en-us/dax/blank-function-dax
Hi Samarth_18 ,
Thanks for your reply, I could understand now that Blank( ) and null aren't same but DAX treats them as same.
And yes, DAX COMPARISON OPERATORS works fine when comparing with Blank( ).