Forum Discussion
Solved
Computing Resource Utilization Per Day, Week and Month
Hi PowerBI Gurus, I'm stucked and I need help. Trying to compute for utilization rate per resource, been able to figure it out if table shows with per resource, but everytime i remove the resourc...
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:
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
is this what you are looking for?