I have a ticketing system with data that I connect to and process. My file is a trimmed down version of the archive. The data has the assigned staff, the project name, estimated hours worked, and date required to complete. This is in my query, Archive.
I have my date table linked to the date completed in Archive.
I have another source with approved project allocations for the staff, per month. This is in my query, Allocations.
I have a list of all people on the team, Team List. This is because the ticketing system is used by other people, so I can filter down to who I need.
My allocation data is month/year. Unfortunately, this is the only way our official system presents it to me. When I change the type to date in the query, the date data type also adds a day.
I would like to divide the hours completed (Archive) in each project by the approved allocation to show a historical capacity usage. I would like to show this weekly.
What should I do to make this work?
Thank you
PBIX File on Google Drive: https://drive.google.com/file/d/19xtv2P4KO2rnLJDRYBQERfNx8UXG6cuc/view?usp=sharing
