Forum Discussion

polaris3028's avatar
polaris3028
Icon for Helper III rankHelper III
8 years ago
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...
Need Help
Show and Tell
polaris3028's avatar
polaris3028
Icon for Helper III rankHelper III
8 years ago

Here's the measure i used for Required Hours,where  #RequiredHours = DISTINCTCOUNT(Table, [Date])*7.5

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

i think ask here is hours spent % again hours required, correct?

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago
    hours spent = SUM(table[hours spent])

hours required = SUM(table[hours required])

% Resource Required = DIVIDE([hours spent], [hours required], 0)

    add above measure and change data format for "% resource required" to "%"

     

     

  • polaris3028's avatar
    polaris3028
    Icon for Helper III rankHelper III
    8 years ago

    yes, parry2k.  sort of utilization rate for a resource.