Forum Discussion
Weird rounding issue
In Power Query, is it being set to whole number type? Sometimes with the auto-type assignment if it only finds whole numbers in the first x rows it'll do that and you have to manually go change it to decimal in that first change-type step in Power Query. If it's whole number and you've added decimal places, it would present as you describe. 🙂
Thank you a million christinepayton ! waking up this morning and switching one of the columns from whole number to decimal number again coupled with with the setting 2 decimal places seems to have fixed it!
I cant say i understand the logic, i only changed whole number to decimal number on one column however it applied the fix across all four columns - so three columns are still set to whole number yet they all changed upon changing one column to decimal number.