Forum Discussion
Shift distribution into excel to review overall Coverage
Here is Power Query solution. Result is
In brief,
- source data is named as Range;
- query it, unpivot shifts, split on start and end
- filter on ThisDay and NextDay. If overnight shift, ThisDay ends at 24:00, NextDay starts at 00:00 and for it change Day name on next weekday
- generate 30-minutes lists for each Start and End, expand it and Pivot on weekday counting employees
SergeiBaklan - Hello, I had to perform this couple of times in the last few weeks but I don't think I could replicate with the steps you defined. What could be an alternate to run this through power query?
Thanks
In theory Power Query could be build in some different way, but that's no warranty you will reproduce it since it's not clear why this one didn't work in your case.
It doesn't work if you open the file above; or if you add another data to that file; or if you copy/paste quires into another file? And there are some errors appear or result is not as you expect or something else.
- Thank You very Much @SergeiBaklan. Seems, your resolution has done the job. I am going to learn PQ, test and apply it on actual sheet so I can understand the solution. By the looks, it seems easy (with logics).
