Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Strange behavior with nested IF when using BLANK

Hi guys,    I'm new to the communtity when it comes to asking questions but I found a bunch of insights here so I hope you can help me with this one 🙂   I'm having problems with Power BI behavio...
  • johnt75's avatar
    johnt75
    4 years ago

    When using the = operator blank does equate to 0. To check for an actual blank value use ISBLANK() instead.

  • SpartaBI's avatar
    SpartaBI
    4 years ago

    you can also use the == operator.
    0 = BLANK() is True
    0 == BLANK() is False

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

you can also use the == operator.
0 = BLANK() is True
0 == BLANK() is False

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you so much for your help 🙂 I feel stupid, I didn't think of it being so simple ğŸ˜…