Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
Hi @Anonymous
Let me know if you'd like to get below one:
Pbix attached
@Anonymous
What's the expected output of your sample data?
Proud to be a Super User!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |