Forum Discussion
Rounding problem
Hi all, I'm having a problem with a financial report. For some reason, three months of the year (Oct-Dec) in my report are rounding my currency values, while the rest of the months of the year are n...
oh got it, have you double check that the data in your model is not rounded for those months as well?
When I click on the Data tab, it shows that data is rounded there for the months of Oct-Nov, but it's all in the same column so I can't figure out why it would round some months and and not others. When I look in the Excel source document that the numbers are pulling from, the data is not rounded there.
If it is rounded in the data tab but not in the excel sheet then the problem must be somewhere in the middle, like power query. Take a look at the steps you have applied in Power Query, maybe one of those steps is rounding those numbers