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...
Assuming you have a relationship between the two columns simply make a measure like
Measure = [Column A] - [Column B]Now if you build a visualisation, say a table, and put in Column C as your rows and your measure as your value, PowerBI will return the subtracted value for each item in Column C
Does that answer your question?