Forum Discussion
Can't remove invisible characters
Based on an export from your report data and some investigation, I noticed that your text contains characters:
8236 - large, ocean-going vessel
8237 - left to right override
When removing those, you're fine to proceed. Code from the formula bar, with data in Column1 resulting in an additional column with numeric data:
= Table.AddColumn(#"Changed Type", "NumericData", each Number.From(Text.Trim([Column1],{Character.FromNumber(8236),Character.FromNumber(8237)})),Int64.Type)To my limited DAX knowledge it is not possible in DAX.
The SUBSTITUE function is close, but there is no function in DAX to convert unicodes to characters and I didn't succeed in copy/paste the special characters into the SUBSTITUTE function.
Again, my DAX knowledge is limited.
BusinessAnalyst Do you have a sample? Have you tried to change the data type of the column to Whole Number, or decimal? This may remove any hidden character, or identify the problem values.
