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 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

 

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.

     

4 Replies

  • 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

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    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.

     

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    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.