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?
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")