Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Am trying to calculate delta value by subtracting Column 2 from column 1, but when column 1 and column 2 are same then getting wrong value. Can anyone help me?
Delta = Sum(column1) - Sum(Column 2)
| Column 1 | Column 2 | Delta |
| -496889 | -496889.08 | 0.08 |
| -64638 | -64637.5 | -0.5 |
| -1192415 | -1192414.73 | -0.27 |
| -316035 | -316035.22 | 0.22 |
| -3279462 | -3279462.09 | 0.09 |
| 2798886 | 2798885.7 | 0.3 |
| -8149336 | -8149335.97 | -0.03 |
| -1000000 | -1000000 | 1000000 |
| -604237 | -604236.8 | -0.2 |
Thank You!
Solved! Go to Solution.
Hi @Anonymous ,
Create a calculated column:
Column = 'Table (2)'[Column 1]-'Table (2)'[Column 2]
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Create a calculated column:
Column = 'Table (2)'[Column 1]-'Table (2)'[Column 2]
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous are you adding DELTA as measure, correct?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 102 | |
| 79 | |
| 57 | |
| 51 | |
| 46 |