Forum Discussion

FZOU's avatar
FZOU
Icon for Helper IV rankHelper IV
6 years ago
Solved

Test Blank Value

Hello,

 

I'm testing a simple column to test blank values on column but i can't get what i want here is an exp :

I had left a blank row to see how it works but without result

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Hmm, what happens if you use

    TestIsBlank = IF([Column2] = "";"A";"B")

    Could you share your PBIX?

5 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    FZOU 

    blank and empty value are not always the same

    1. make sure you have no service symbols in your column (execute trim operation in Power Query)

    2. try statement like

    = IF(ISBLANK(table[Column]) || table[Column]=''; "a"; "b")
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago
    Hmm, what happens if you use

    TestIsBlank = IF([Column2] = "";"A";"B")

    Could you share your PBIX?
    • FZOU's avatar
      FZOU
      Icon for Helper IV rankHelper IV
      6 years ago

      Greg_DecklerIt works fine but why the ISBLANK function doesn't work properly ? maybe i'm not use it correctly 

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        6 years ago
        I have seen this before, for whatever reason how you created it, it isn't really "blank" as in null. I'm actually not certain why it happens but I have run into it before and had to work around it.