Forum Discussion
Solved
Calculating difference between 2 columns
Hi All, I have added a DAX statement to calculate the difference between 2 columns. I am getting some wierd scietific number instaed of 0 when two columns values are exaclty same A ...
Hi revansh ,
this is a decimal precision-related problem.
Hope this helps to understand.
https://www.sqlbi.com/articles/choosing-numeric-data-types-in-dax/
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi revansh ,
this is a decimal precision-related problem.
Hope this helps to understand.
https://www.sqlbi.com/articles/choosing-numeric-data-types-in-dax/
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.