Forum Discussion
Newbie_77
7 years agoFrequent Visitor
Sum Rows from Different Tables, Deduct from Start Value
Hi All, I'm sure this is really simple, searched and found similar but not the right answer. I have 3 data source tables, combined into a BI table. I need to add some totals plus deductions....
Anonymous
7 years agoNot applicable
You can do this using the query editor and then a DAX column for the End Value:
- In the query editor select Merge Queries as New
- Use Table1 as your top table and Table2 as your bottom table and select the Project number on both tables. Select Full Outer as your join type.
- In the new Merge1 table hit the double arrow button next to the Table2 comlumn heading and click OK on the window that pops up:
- Now select the Merge Queries option (not Merge Queries as New) and join the new Merge1 table with Table3 the same way you did on the first merge:
- Repeat step 3 on the Table3 column
- Delete the 2 extra project number columns and rename the other 2 columns
- After you close and apply, create a new column in the Merge1 table using this DAX:
End Value = Merge1[Start Value] - Merge1[Value Day 1] - Merge1[Value Day 2] - Output: