Need to replace cell value with dynamic value

Question

Hi, I need help to create a dynamic table

Lets say I have 2 table as below

Table1:

Table2:

What I need:

1. Calculate sum of 2017, 2018, 2019 profit and sum of cost in table2 as below

2. I need the sum of profit and cost to be dynamic as i filter the product

example: Top 3 product based on profit

here is the link of the report

I'm new to Power BI so any help will be much appreciate.

lbendlin · Answer

Your first step will be to unpivot table 1. The rest can then be done in the UI.

Forum Discussion