Forum Discussion
Anonymous
4 years agoNot applicable
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...
- 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
4 years agoCommunity Support
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.