Need Help in changing (null) to unknown

[Anonymous]

Hi Team,

I have a column where in the UI i am getting values as (Blank) but when i see in the query editor in the data it is showing me as (null) , I have to replace that with Unknown , I have tried replacing the vlaues by these options 

empty to unknown 

null to unknown 

(null) to unknown

but the value doesn't changes 

even i used this in new column, its not working

Column =     if (   isblank( 'Incidents' [Province]),  "Unspecifed" ,   'Incidents' [Province])

But still not working 

please kindly help

Thanks & regards

Shiv Kumar

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

If you use a conditional statement in a Power Query, first of all, the symbol of your expression is incorrect. You can change it to:

You could try it.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , in power query replace you can use all small cap null

Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk

check if that empty space

Column = if ( isblank( 'Incidents' [Province]) || 'Incidents' [Province] = "" , "Unspecifed" , 'Incidents' [Province])

[Anonymous]

Hi Amit , @amitchandak 

I did replace it most of the options but it didn't replaced , 

On the 2nd option 
I am getting an error 
if ( isblank([Final Classification] = "", "Unknown" , [Final Classification]) for this calculation 
Error : Token RightParen Expected.
Thanks & Regards

Shiv kumar