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:
i think ask here is hours spent % again hours required, correct?
yes, parry2k. sort of utilization rate for a resource.
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. :)