conditional calculation based on various column values

[Anonymous]

Dear team, 

Please help me with a solution for problem statement 

Date    Parameter   Unit     Value   Reason 

20/6           P1         MW       10         Boiler

20/6           P1         Hours     8          Boiler

20/6           P2         MW       12         Turbine

20/6           P2         Hours     9          Turbine

20/6           P3         MW       11         Boiler

20/6           P3         Hours     9.5        Boiler

21/6           P1         MW        9          Boiler

21/6           P1         Hours     8          Boiler

21/6           P2         MW       15         Turbine

21/6           P2         Hours     9          Turbine

21/6           P3         MW       11          Grid

21/6           P3         Hours     9.8        Grid

From this, I want to calculate 

Measure 1= Boiler MW total (when Reason == Boiler and Unit = MU)  =  10+11+9 = 30

Measure 2= Boiler Hours total (when Reason == Boiler and Unit = Hours)  =  8 + 9.5 +8 = 25.5

Measure 3= Turbine MW total (when Reason == Turbine and Unit = MU)  

Measure 4= Turbine Hours  total (when Reason == Turbine and Unit = Hours )  

Basically I want to calculate the addition of values when Reason = " " && unit =" " for selected number of dates as per user( in this case 20/6 & 21/6)

Please help me!

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Let me know if you'd like to get below one:

Pbix attached

[ryan_mayu]

@Anonymous 

What's the expected output of your sample data?