Forum Discussion

bourne2000's avatar
bourne2000
Helper 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 value 

 

Again I tried to convert into fixed decimal

 

 

 

Here the decimal points are not coming correctly.  Can you please advise why this is happening? My data comes from SQL server

 

 

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

     

4 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    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
    Super 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

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    bourne2000 , seem like because of a regional setting comma, is a decimal seprarator.

     

    Not the full stop/dot (.)

     

    So replace . with , first and then try to convert