Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |