Forum Discussion
Solved
Can't replace different null values in Power Query
I have a column that has blank cells, which register as null, and cells with the text string "null". The standard course of action is to replace values with Value To Find = "null" and Replace Wit...
A little bit of experimentation should get you there.
I suggest adding the Replace Values for the null value ( using the interface) and then editing the M code in the formula bar or Advanced editor to be something like:
Table.ReplaceValue(#"Changed Type","null"......
A little bit of experimentation should get you there.
I suggest adding the Replace Values for the null value ( using the interface) and then editing the M code in the formula bar or Advanced editor to be something like:
Table.ReplaceValue(#"Changed Type","null"......
Thank you HotChilli. Editing the M code from null to "null" did the trick!