Calculating multiple columns from two different tables

Hi CA8172 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

I have a solution as below:

Assume your data is like

In Edit queries,

1. unpivot other columns for "purchased" column, the same for "sold"

2. Rename columns, then groupby columns

The same for " Sold" table(Table 2)

3. Then merge two tables, expand value

Finally, close&&apply, create a measure

Inventory = SUM('Table 1'[purchased value new])-SUM('Table 1'[Table 2.sold Value])

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.