Forum Discussion
Solved
Subtraction Problem between two tables
Hi all, i am currently trying to do a simple subtraction between two columns from 1 table and then followed by another subtraction from another table. They are all $ values but i keep getting this error.
jkesavan , In case you are
creating a measure
Sum(Table1[Col1]) + Sum(Table1[Col2]) -Sum(Table2[Col1])
if you create creating a column in table 1
Table1[Col1] + Table1[Col2] - sumx(Filter(Table2, table2[Id] = Table1[Id]),Table2[Col1])
1 Reply
jkesavan , In case you are
creating a measure
Sum(Table1[Col1]) + Sum(Table1[Col2]) -Sum(Table2[Col1])
if you create creating a column in table 1
Table1[Col1] + Table1[Col2] - sumx(Filter(Table2, table2[Id] = Table1[Id]),Table2[Col1])