Forum Discussion
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 B A-B
9.20 9.20 1.76636-e15
please help.
Thanks
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.
2 Replies
- mwegenerMost Valuable Professional
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. - v-lionel-msftCommunity Support