Forum Discussion
Solved
Convert text to number
Hello I have a column of numbers that was imported as a text. I wanted that changed to a Fixed Decimal Number. This needed to be the case in 2 columns. In both columns every cell converted a...
Replace "%" before to convert to number the columns.
A guide:
Step 1:Step 1: Edit QueryStep 2: First row as headerStep 3: Delete first rowStep 4: Replace %Step 5: Convert to NumberStep 6: Ready
ankitpatira
Community Champion
Community ChampionJGSmith123 first row has value '24.80%' where '%' is blocking it to be converted to a number. You can simply do replace values in power bi desktop query editor and remove '%' sign and that should work.