Forum Discussion
Calculation if ID match
Hey all, i need to create a calculation that substract an amount from table1 from table2. (Amount from table1 - amount from table2). This should be based on if the ID's match. So if Reference ID f...
Hey, yes. The last row of Desired output should be 300. thanks for highlighting this.
Hi,
In table2, write these calculated column formulas
Table1 reference ID = calculate(max(Table1[reference ID]),filter(Table1,Table1[reference ID]=earlier(Table2[id])))
Amount = calculate(sum(Table1[amount]),filter(Table1,Table1[reference id]=earlier(Table1 reference ID)))
Hope this helps.