how to find an anormal data if blank ?

[Anonymous]

Hi, 

I found an anormal data if this data is blank following the check thanks by the function :

name_in_mms_w = ISBLANK(Demand_Ref[name_in_mms])

. "False" is displayed in the tempory column named " name_in_mms_w. Normally, it must appear " true " and no "false". 

. See snapshot screen  below. How to do to find this anormal data ? maybe the hidden  special caractere ? or something ?...

(I tried to use the replace value with advanced option where there is "carribon return" . it doesn't work . Perhaps, I didn't do well ... ) 

thank you for the help. 

[v-gizhi-msft]

Hi,

According to your description, it is because the column [name_in_mms] type is text and it has blank string not blank.

I create a table to test, create a column to check and it shows:

So, please try to change its blank to null in Query Editor:

Note: Remember to leave one blank in red circle above.

And it shows:

After Apply&Close, it shows the correct result:

Best Regards,

Giotto Zhi

[Anonymous]

thank you for your answer.

I tried it all of time. It doesn't work !... we don't see displayed "null" in power Query !... 

Then, I think that, there are hidden sometime as special characters...   

How to do it to appear the hidden values ?