Number Inconsistency

[Anonymous]

Hi All,

I have the following issue where i have a dataset wich contain sales actuals by month. example below:

JAN - 120.45

FEB - 45.34

MAR - 63.58

APR - 120.67

MAY - 567.34

JUN - 234.44

JUL - 345.45

AUG - 230.00

Correct would be  AUG - 245.35

Apperantly if you look at the month of AUG the numbers apear to be rounded automatically for some reason. This creates an incorrect number in the last month.  This happens every three month or so. The only way to fix this is to re-import the data into the model. This will fix it for a few months where it happens again. Anyone has experienced anything like this before? 

how can i fix? 

Kind Regards,

[Anonymous]

@Anonymous ,

Any chance you can upload a sample of the data?  Something is happening there and Power Query should be able to clean that up, but would need to see some of the data if possible.