Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone, I've got this table:
For each day, I've got the list of operators who worked in each WC (Work Center), their start time anda end time. The column Available minutes is equal to 225 if the date is a Saturday, 450 otherwise. The column Elapsed minutes is given by Datetime End - Datetime Start.
My purpose is to get for each Day, for each WC the available minutes of that day and the total elapsed minutes. The problem is that I would like to have 450 as available minutes of the day, not the sum for each Operator, and the total sum of the Elapsed minutes.
This is the ideal result (referred to the whole table) obtained through a pivoting with Excel:
Here is the xlsx file: https://www.dropbox.com/scl/fi/ujxx5dvq7auw48xqjr0u5/Cartel.xlsx?dl=0&rlkey=ozoej78y0zlj22198t8lsdgl...
Thank you!
Solved! Go to Solution.
I attempted a solution. Using this as the sample data:
Result:
Basically I used Power Query to:
Proud to be a Super User!
I attempted a solution. Using this as the sample data:
Result:
Basically I used Power Query to:
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |