Weekly Average of Hours worked by Employee

[jayvataliya]

Hi

Below is the sample data where I am trying to get the weekly avg of hours worked by an employee.

EmployeeID	Name	Hours	TypeOfHours	StartDate	EndDate	Week number
101	Emp A	72.35	Admin time	28-12-20	03-01-21	53
101	Emp A	91.51	Client time	28-12-20	03-01-21	53
101	Emp A	55.78	Admin time	01-02-21	07-02-21	6
101	Emp A	95.7	Client time	01-02-21	07-02-21	6
101	Emp A	49.01	Admin time	01-03-21	07-03-21	10
101	Emp A	123.43	Client time	01-03-21	07-03-21	10
101	Emp A	59.5	Admin time	29-03-21	04-04-21	14
101	Emp A	96.63	Client time	29-03-21	04-04-21	14
101	Emp A	66.32	Admin time	26-04-21	02-05-21	18
101	Emp A	101.21	Client time	26-04-21	02-05-21	18
101	Emp A	54.62	Admin time	31-05-21	06-06-21	23
101	Emp A	110.16	Client time	31-05-21	06-06-21	23

Any assistance on how can I get avg. hours worked on a weekly basis?

[amitchandak · Accepted solution]

@jayvataliya , Try like

AverageX(summarize(Table, Table[EmployeeID], Table[Week Number], "_1", Sum(Table[Hours])),[_1])

[jayvataliya]

Thanks, @amitchandak .  This is what I was looking for.

One quick que. What is the use of putting _1

[jayvataliya]

I see, _1 is the column name for sum of Hours