Calculate totals per variable costs

Power BI
2

Hi @Thimios,
It would be great if we can have a look at your model and the tables. But try this anyway :

  1. reate a key in both tables : Sales and UNIT COST to link both.
    Year&Month&SKU.

  2. Create a relationship between the two using that key.

  3. Add a calculated culumns that gets the unit cost from the UNIT COST table into Sales table (Using RELATED function).

  4. Then you can create a measure of your cost :

     `Total Cost = SUMX (Sales, Qty * Unit Cost )`
1 Like