Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need Help in changing (null) to unknown

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...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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