Forum Discussion
Solved
Average Head Count by Week
Hi, I am trying to calculate average head count by ISOWEEK. I have a data table that contains employee number, employee name, date of shift, position, isoweek. As the data has an inidvidual line for ...
Hi sdas028,
You should use the following formula and check if it works fine.average=COUNTROWS(Table)/DISTINCTCOUNT(Table[Emplyeename])
Best Regards,
Angelia
I have managed to also get to this table - however I would have thought that the average for week 21 should be 5? 20 shifts in one week worked by 4 people should give an average of 5, or perhaps I am incorrect in my thinking and possibly overthinking the calculation
Is week 21 a complete or partial week?
Do you mean did they work a full week?
Hi sdas028,
You should use the following formula and check if it works fine.average=COUNTROWS(Table)/DISTINCTCOUNT(Table[Emplyeename])
Best Regards,
AngeliaBrilliant!