Calculating Technician Utilization

[PBI_newuser]

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 available hours in my calculation?

I need to analyse the utilization by month, by year, by team, by technician.

Team	Technician	Work Order	Labor hours	Travel hours	Resolution Date
Alpha	Eric	A-123	3.5	1.2	05-12-19
Alpha	Eric	B-123	2.5	3.5	03-01-20
Alpha	Aaron	C-123	6.4	1.2	12-02-20
Alpha	Richard	D-123	5.2	4.2	15-02-20
Alpha	Richard	E-123	6.2	1.1	24-01-20
Alpha	Richard	F-123	4.4	3.2	03-04-20
Beta	Joshua	G-124	2.5	3.5	24-04-20
Beta	Robert	H-124	6.4	1.2	30-12-19
Beta	Robert	I-125	6.2	1.1	23-02-20
Beta	Mike	J-125	4.4	3.2	08-03-20
Beta	Mike	K-126	3.5	1.2	07-01-20
Beta	Joshua	L-126	5.2	4.2	03-04-20

[amitchandak · Accepted solution]

@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])))