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

[bourne2000]

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

[PhilipTreacy · Accepted solution]

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

[amitchandak]

@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

[PhilipTreacy]

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]

@PhilipTreacy Thanks. Yes I am doing the same

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