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"......
Didn't even think of checking the advanced editor. You nailed it, needed to put quotes around null to distinguish it as a string as opposed to the usual null. Thank you!