Forum Discussion
FZOU
6 years agoHelper IV
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
- 6 years agoHmm, what happens if you use
TestIsBlank = IF([Column2] = "";"A";"B")
Could you share your PBIX?
Greg_Deckler
6 years agoCommunity Champion
Hmm, what happens if you use
TestIsBlank = IF([Column2] = "";"A";"B")
Could you share your PBIX?
TestIsBlank = IF([Column2] = "";"A";"B")
Could you share your PBIX?
FZOU
6 years agoHelper IV
Greg_DecklerIt works fine but why the ISBLANK function doesn't work properly ? maybe i'm not use it correctly
- Greg_Deckler6 years agoCommunity ChampionI 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.