Forum Discussion
ikawaljeetsingh
Sep 05, 2020Copper Contributor
Shift distribution into excel to review overall Coverage
I was recently working on a spreadsheet to review the overall coverage where I entered the numbers manually by looking at shifts for each employee for the entire week. I was thinking of applying a fu...
ikawaljeetsingh
Nov 11, 2020Copper Contributor
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
SergeiBaklan
Nov 11, 2020Diamond Contributor
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.