Strange behaviour when deducting decimal numbers - precision issues?
Hi,
I hope I'm not going crazy - it seems that Power BI is adding some random junk to the very far decimal positions when doing some basic math operations.
Let's do some basic test:
Column = (1-0.5-0.5)=0
This produces TRUE, as expected.
Column = (1-0.6-0.4)=0
Also TRUE
Column = (1-0.7-0.3)=0
FALSE
I noticed that when comparing a KPI threshold of 0.05 to a number which was basically (1-19/20), which is 1/20, which is exactly 0.05.
However, that does not seem to be the case in Power BI:
(1-0.95)>0.05
TRUE
(1-0.95)>0.05000000000000004093
TRUE
(1-0.95)>0.05000000000000004094
FALSE
Note that I'm working only with numbers entered directly here, there are no columns involved, whose data type settings could be at play.
Is there an explanation for this?
I have tried this in multiple projects.
I'm using Microsoft Power BI Desktop (Optimized for Power BI Report Server - August 2018)
Version: 2.61.5192.641 32-bit (August 2018)
Thank you!
- Anonymous7 years agoNot applicable
Also note that parentheses have no (unexpected) effect on the outcome.