How to deal with null value and blank value in power Query ?

Hi Clarafang ,

As far as I know, Power BI will show empty data in number format by null and show show empty data in text format by nothing.

If you want to replace null value or use null value in M code, you need to use find null.

If you want to replace text nothing value , you can write nothing to find it. 

And you need to use "" to find it in M Code.

If this reply still couldn't help you solve your problem, please share a sample file with me and show me the result you want.

Best Regards,
Rico Zhou

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