Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculating Utilization -- Multiple Employees; different Number of Weeks

I am trying to figure out how to build a formula that will provide the utilization for multiple employees with reporting in a different number of weeks.   In the table below, Bob worked Jan - Apr, ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous - 

    Try this Measure:

    Util = 
var summary = SUMMARIZE(util, Util[Name], Util[Week Number], "Hours", SUM(Util[Billable Hours]), "Weeks", 1)
var hours = SUMX(summary, [Hours])
var weeks = SUMX(summary, [Weeks])
return DIVIDE(hours, (weeks * 40))

    Hope this helps,

    Nathan

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous - 

Try this Measure:

Util = 
var summary = SUMMARIZE(util, Util[Name], Util[Week Number], "Hours", SUM(Util[Billable Hours]), "Weeks", 1)
var hours = SUMX(summary, [Hours])
var weeks = SUMX(summary, [Weeks])
return DIVIDE(hours, (weeks * 40))

Hope this helps,

Nathan

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you Nathan,

 

Using the guidance you provide I was able to modify thigs to meet my needs. It worked!! Many, many thanks for your assistance!!