Forum Discussion

Sweetie's avatar
Sweetie
New Member
5 years ago
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...
Sweetie's avatar
Sweetie
New Member
5 years ago

Hi Samarth_18 ,

 

I was going through 

@https://youtu.be/C26DQkb4hy where in got to know Blank( ) and Null aren't same! 

So do we have any possibilities to compare a value with null.

If we have such It would be really helpful.

 

 

 

  • Sweetie's avatar
    Sweetie
    New Member
    5 years ago

    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( ).