Forum Discussion

bharri's avatar
bharri
Frequent Visitor
5 years ago
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...
Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    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"......

HotChilli's avatar
HotChilli
Community Champion
5 years ago

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"......

  • bharri's avatar
    bharri
    Frequent Visitor
    5 years ago

    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!

  • PhilDanley's avatar
    PhilDanley
    Advocate I
    3 years ago

    Thank you HotChilli. Editing the M code from null to "null" did the trick!