How do I specify NULL in Power Query?

[Anonymous]

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!

[v-lionel-msft]

Hi @Anonymous ,

@amitchandak  is right. Pay attention to case sensitivity.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

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