Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts,
I'm trying to replace values - to blank or null in a columns using:
= Table.ReplaceValue(#"Renamed ColumnsY",Number.FromText("-"), null,Replacer.ReplaceValue,{"ColumnX"})
However I get the following error:
DataFormat.Error: We couldn't convert to Number.
Details:
-
Is there an easy wayt to overcome this?
Thanks in advance!
Solved! Go to Solution.
Don't use Number.FromText("-"). Since you are trying to replace "-" with null, hence Number.FromText is not needed. This will give error as "-" can't be identified as number.
Use below
= Table.ReplaceValue(#"Renamed ColumnsY","-",null,Replacer.ReplaceValue,{"ColumnX"})
Yes, and then I could use Replace Errors instead. Thanks!
Don't use Number.FromText("-"). Since you are trying to replace "-" with null, hence Number.FromText is not needed. This will give error as "-" can't be identified as number.
Use below
= Table.ReplaceValue(#"Renamed ColumnsY","-",null,Replacer.ReplaceValue,{"ColumnX"})
Yes, and then I could use Replace Errors instead. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |