Forum Discussion
Calculating Average Hours Worked/Week by Week, Month, Year
Hey everyone, I believe this should be a fairly straight forward question, so let's give it a shot! I have a very simple database that tracks daily employee hours worked (see below for a small sample...
Just wanted to give this a bump, so close!
Hi Anonymous
On my side,
Please show me your formula about the "total week" measure.
I modify my formula "total week" as below, so i can get 12 as you show
days_per week = CALCULATE(SUM('date'[weekday]),FILTER(ALLSELECTED('date'),'date'[weeknum]=MAX('date'[weeknum])))
total week = COUNTX(FILTER(VALUES('date'[weeknum]),[days_per week]=28),'date'[weeknum])
Best Regards
Maggie