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

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Awesome, thank you, that did the trick 😄 I love how this community is filled with awesome people willing to help out!