Forum Discussion
Solved
Calculated column between two tables
Hi, I have 2 tables: 1. Revenue - each row is a sale. 2. Costs - Each row is a cost action. The only Connection between these two tables is the date, so I made a table like this: Column1 Colu...
Hi barlevitzky
You ought to use "Calculate". Calculate transforms ROW CONTEXT into FILTER CONTEXT
In Column2 use (Modify the table name according to your situation)
=calculate(Sum(RevenueTable[Revenue])
In Column3 use (Modify the table name according to your situation)
=calculate(Sum(CostTable[Cost])
Hi barlevitzky
What about ....
Column4 = [Column2] - [Column3]
Hope That Helps