Forum Discussion
Robin96
Helper II
Helper IICalculation 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...
ryan_mayu
Super User
Super Userthen you change the column to
Column = maxx(FILTER('Table 1','Table 1'[id]='Table 2'[id]),'Table 1'[reference id])+0
