Rolling hours up by week and employee

[jritchey]

I have a dataset that brings in invidual days by employees and the hours they have submitted. It also has the "Week Of" that it belongs to. So for example:

Date      Employee    Hours  Week Of

6/1/20  John Smith       5      6/6/20

6/2/20  John Smith       4      6/6/20

6/3/20  John Smith       8      6/6/20

6/4/20  John Smith       2      6/6/20

6/1/20  Jane Smith       3      6/6/20

6/2/20  Jane Smith       8      6/6/20

6/3/20  Jane Smith       2      6/6/20

6/4/20  Jane Smith       8      6/6/20

I'm looking for a measure or a calculated column to roll the hours by day into the week they belong to and by employee?

[lbendlin]

This should get you going

https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax

group_by is Employee and Week of