Forum Discussion
How do I specify NULL in Power Query?
Hello
I want to populate a field with NULL via Power Query.
I did Column="" but this is limited to text only fields.
How can I specify the NULL value for any kind of field, i.e. numerical, text etc?
Thanks!
Anonymous ,
I think it is
Column= null
if [column] = null
also refer :http://excel-inside.pro/blog/2018/05/17/comparing-null-values-in-power-query/
2 Replies
Anonymous ,
I think it is
Column= null
if [column] = null
also refer :http://excel-inside.pro/blog/2018/05/17/comparing-null-values-in-power-query/
Hi Anonymous ,
amitchandak is right. Pay attention to case sensitivity.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
