cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SiennaLei Frequent Visitor
Frequent Visitor

ROUNDING ERROR

 

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!

 

 

ROUNDING ERROR.PNGTEST ROUND.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: ROUNDING ERROR

Hi @SiennaLei,

 

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.

 

test.PNG

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: ROUNDING ERROR

Hi @SiennaLei,

 

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.

 

test.PNG

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SiennaLei Frequent Visitor
Frequent Visitor

Re: ROUNDING ERROR

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

Community Support Team
Community Support Team

Re: ROUNDING ERROR

Hi @SiennaLei,

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.