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