Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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}})
Solved! Go to 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"
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"