Forum Discussion

Sab's avatar
Sab
Helper V
5 years ago
Solved

Error converting percentages

Hello   as you see in the screeshot below, when I load these percentage data, the negative ones stay as Text and I don't know why!!! I cannot convert them to number. There is no Chnage Type step in...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Your column is not converted to a number type, it's still type any. As long as you have the header row in your data instead of promoting  them to headers. Ideally you'd format the Excel data as a table, and then no work would even be necessary, except to click the Get Data From Table/Range button.

    Once you Promote those headers, you can probably use:

    Fixed = Table.TransformColumns(PriorStep,  {{"Premium % Change", Number.FromText}})

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Your column is not converted to a number type, it's still type any. As long as you have the header row in your data instead of promoting  them to headers. Ideally you'd format the Excel data as a table, and then no work would even be necessary, except to click the Get Data From Table/Range button.

Once you Promote those headers, you can probably use:

Fixed = Table.TransformColumns(PriorStep,  {{"Premium % Change", Number.FromText}})

 

--Nate