User Profile
KHarrisonSJCA
Copper Contributor
Joined Nov 01, 2023
User Widgets
Recent Discussions
Re: Workload Projection
NikolinoDE , Thank you so much for your reply to get me started. I didn't get too far, however. When I added the custom colum and used the List.Dates formula, I received "Error" in those cells. See the attached screenshot and maybe you can see where I am getting tripped up. (Forgive me as the Power Query Editor is a totally new tool for me!)Workload Projection
I am trying to work out a method of calculating our workload projection based off employee types across multiple projects. The input I have is: - Project No - Start Date - End Date - Total Project Hours for Employee Type 1 - Total Project Hours for Employee Type 2 This information is input from multiple project with varying dates and hours. In the end, I was wanting to see the total number of hours per month that each employee type is projected to have. I want this to be flexible so that I can continue to add additional projects in the future as well as extend the timeframe to always be a couple years out. Not sure if there is other information needed to help resolve, but reach out and I will respond ASAP. I've attached the format of what I have so far, but am in no way tied to this. Thanks for any help that can be provided!
