HELP! How to work out total hours worked per employee per week?

[lennox25]

Hi - Please can someone help with creating a column/measure  to calculate the total hours worked per employee per week?

HoursWorked	PersonName	FinYear	Week Number
13	Employee A	2019/20	1
12	Employee A	2019/20	1
13.5	Employee B	2019/20	1
12.5	Employee B	2019/20	1
11.5	Employee C	2019/20	1
8.25	Employee C	2019/20	1
8.25	Employee D	2019/20	1
9.5	Employee D	2019/20	1
4.5	Employee E	2019/20	1
6	Employee E	2019/20	1

[lennox25]

Hi @danielwelch thank you

[danielwelch · Accepted solution]

Hi,
New calculated column:

CALCULATE(sum('Table'[HoursWorked]),filter(all('Table'[HoursWorked]),

'Table'[PersonName]=earlier('Table'[PersonName]) &&

'Table'[FinYear]='Table'[FinYear] &&

'Table'[Week Number]='Table'[Week Number]))

Hope this helps