Forum Discussion

JGSmith123's avatar
JGSmith123
New Member
10 years ago
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...
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    JGSmith123

     

    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's avatar
ankitpatira
Community Champion
10 years ago

JGSmith123 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.

JGSmith123's avatar
JGSmith123
New Member
10 years ago

Thank you very much for your response!

 

Here is a picture of me trying to do just that but I keep getting an error message saying that I need to enter a numerical value.

 

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago
    JGSmith123 wrote:

    Thank you very much for your response!

     

    Here is a picture of me trying to do just that but I keep getting an error message saying that I need to enter a numerical value.

     

    JGSmith123

     

    Undo the "Changed Type" step (namely revert this column from decimal to text) and then replace the "%" with blank.

     

    I've also noticed that there're more invalid rows appended. Do remember to uncheck them.

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    10 years ago

    JGSmith123

     

    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