Calculating difference between 2 columns

[revansh]

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

[v-lionel-msft]

Hi @mwegener ,

I think so.

Regards,

Lionel Chen

[mwegener · Accepted solution]

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.