Test Blank Value

[FZOU]

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

[amitchandak]

@FZOU , try

if(coalesce(Table[Column2],"")="","A","B")

[Greg_Deckler · Accepted solution]

Hmm, what happens if you use

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

Could you share your PBIX?

[FZOU]

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

[Greg_Deckler]

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.

[az38]

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