Replace Errors

[Hashiru]

Hi all,

if I want to set the error values in a numeric column to zero using the query editor, does the following line of code will solve the problem?

#"Replaced Errors" =Table.ReplaceErrorValues(#"Changed Type",{{"CustomerID",0}})

[v-frfei-msft · Accepted solution]

Hi @Hashiru ,

You code should be ok.

M code for your reference.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("ddFLCoNAEIThu/TahVXj8wa5w+BCUExA3CXnT0jS0kLN9qc2H5Wz3dZ5eRwbrLLXvD9X2FRlu/8qvfJb/9vkNcXaeG1ibb22sXZeu1h7r32sg9ch1tHrGCvqk1Ff+pk1D9oHDYQWQhOhjdBIaCUKTGomCy9qJjWTmknNpGZSM6mZLDDThzm9AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [RH = _t, Values = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"RH", type text}, {"Values", type text}}),
    gourp= Table.Group(#"Changed Type", {"Values"}, {{"RH", each """" & Text.Combine(List.Transform(_[NumberColumn], (x) => Number.ToText(x)), ",") & """", type text}}),
    #"Replaced Errors" = Table.ReplaceErrorValues(gourp, {{"RH", "0"}})
in
    #"Replaced Errors"