Forum Discussion
Computing Resource Utilization Per Day, Week and Month
Wow that fixed it! I changed the relationship to both and changed the %Utilization to use:
%Utilization = DIVIDE([#Hours Spent],SUM('Developer Date Table'[Hours Required]),0)
You're amazing parry2k!
Here's the result that makes more sense. :)
hahaha, same here, Bud. Thanks a lot! You're a great help..:smileyhappy:
Here's the link to the file that I'm working on. Hope this helps.
https://drive.google.com/file/d/1v84kSThkFZHJKbIaDG2vOpCK-b9XyKvd/view?usp=sharing
ok, no worries, which tab should I focus on?
The Utilization tab please. :)
what output your are expecting? you already have stuff on there, so not sure what is not working?
per resource it looks good, but the sum utilization for the entire day is not correct. The GrandTotal for #Hours Required for the day is not 7.5, but should be #Resource*7.5