Forum Discussion

uzeq's avatar
uzeq
Advocate I
4 years ago

Measure with month vs week

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