ROUNDING ERROR

[Anonymous]

When I round my data in the power bi, it has some problem. I am not using ROUN UP nor ROUND DOWN, just ROUN to 0 decimal point.

Most of the data works, but there are some random mistakes. e.g. 4,271.16 was rounded into 4,272 while 267.57 was rounded into 267.

If I ran a test on just these two numbers, it returned the correct results!

I really don't know what's going on and how to fix this. 

Please help!!

Thank you!

[v-piga-msft · Accepted solution]

Hi @Anonymous,

By my test with the my Power BI Desktop , I cannot reproduce your issue. Please check if you have installed the latest version of Power BI Desktop.

You also could have a reference the attachment.

If you still need help, please share your pbix file whcih could reproduce your issue so that we could help further on it.

Best Regards,

Cherry

[Anonymous]

Hi Cherry,

Thank you for your reply. I have updated my Power BI Desktop but the problem still exists. I cannot reproduce the exact issue too since it seems to be random. 

I may just have to convince my manager that this is just a rounding error and accept the less than 0.01% error rate and move on.

Thank you,

Sienna

[v-piga-msft]

Hi @Anonymous,

Have you solved you problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry