Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating Technician Utilization

Hi,    I want to calculate the technician utilization as formula below Utilization = (Labor hours + Travel hours) / Hours Available Hours available per month = 160 How can I fix this 160 avail...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    @PBI_newuser, create a month-year column or take it from the date table

    avergageX(summarize(table,table[Month-year],table[Team],table[Technician],"_1",160,"_2",sum(Table[Labor hours])+sum(Table[Travel hours])),divide(sum([_2]),sum([_1])))

amitchandak's avatar
amitchandak
Super User
6 years ago

@PBI_newuser, create a month-year column or take it from the date table

avergageX(summarize(table,table[Month-year],table[Team],table[Technician],"_1",160,"_2",sum(Table[Labor hours])+sum(Table[Travel hours])),divide(sum([_2]),sum([_1])))