Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |