Forum Discussion

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper V
4 years ago
Solved

Getting wrong value when I convert the column in decimal in Power query?

Hi   I am having below column called "Amount" which is in Text type   I am trying to convert this column in decimal number in Power Query and getting below values. It replaces the decimal v...
Need Help
Show and Tell
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi bourne2000 

    Right click in the column header and try using Change Type -> Using Locale

     

    Then select Decimal Number and the locale of the origin of the data

     

    Regards

    Phil

     

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
4 years ago

Hi bourne2000 

How are you doing the conversion?  By clicking on the ABC icon in the column header and choosing Decimal Number?

If you do this then you should get a step with the code

= Table.TransformColumnTypes(Source,{{"Amount", type number}})

Are you seeing this?

Can you share your data file?

Regards

Phil

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper V
4 years ago

PhilipTreacy Thanks. Yes I am doing the same

 

This is what I am getting, I removed the first row