Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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 @UsePowerBI ,
@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.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |