Hello,

I have a power pivot with 2 different tables.
One table has SKU list with QTY Sold
Another table has SKU list with Price per Unit

Is there a way to create calculated filed and look up those SKUs then multiply QTY SOLD * Price per unit between two tables?

Thanks