Stop Power Query Rounding

[Shnn028]

I have searched the Videos and Forums and am not able to find any answers. I have a Power Query that rounds some of my amounts to the dollar and some that do not. I do not want any of it to round. Can someone help me? Thank you!

 

[Alex Blakenburg]

Firstly what is the data type that Power Query is using for the amount field you are referring to ?

If this is ABC123 or 123, you need to find the Changed Data Type step that made it this type and remove/change it.
You need the column to show a data type of 1.2 Decimal (or if 4 decimals is enough then $ Currency)

It is most likely that the very 2nd step was Changed Data Type step. If this is the case and then click on that step and check if the column at that point already 123 (or ABC123).
Click on the 123 (or ABC123) and select say 1.2 Decimal no.
If it then shows the option to "Replace current" the select that.
If it creates a new Changed Type step you will need to delete the original change type step.

Note: you can not change it "back to" 1.2 or currency after a step that has converted it to "123 whole number.
The initial conversion will have lost the decimals and changing it back after does not recover the lost data,

.

 

[Shnn028]

Thank you so much it worked! I had 6 Worksheets with multiple columns that I had to change the Data Type on. I was able to select multiple columns and change them on each worksheet; however is there a way to do it without having to change them on each worksheet?

 

[Alex Blakenburg]

Not if they are all separate independent queries.
If they are all appended or merged together then you could delete the changed type step and apply it after they are all appended or merged.

 

[Shnn028]

Thank you for your help!

 

[Alex Blakenburg]

Thanks for the feedback. Happy to help.