Forum Discussion
paulfink
Post Patron
Post PatronSubtracting Columns from 2 Tables
Hi guys, i need help with DAX as im trying to subtract two columns in two different tables but they each have columns with the same names which i need so that i can have a total. What i am tr...
amitchandak
Super User
Super UserFirst Aggregate then you be able to
Like Sum(table1[A]) - Sum(Table2[A])
But the information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
paulfinkhi amitchandak,
here is a dummy Excel file i put together to show my situation
on the left is an example of the data i have, the right is what is should look like in power bi.
This is probably a simple A - B formula but on my power bi it is subtracting it per row instead of totally the subtracted amount.
thank you.