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:
yes it need to be column, the file you sent me in that #Hours Required 2 is a column and that is why I used that one, seems like you are making chages at your end at the same time :(
Opps, sorry about that. I restored the previous version and did as instructed. After creating the relationship below:
Here's the result of the table. Is there another step to take after this?
It's not correct stil. :(