Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
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 ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    You should use the following formula and check if it works fine.

    average=COUNTROWS(Table)/DISTINCTCOUNT(Table[Emplyeename])


    Best Regards,
    Angelia


Anonymous's avatar
Anonymous
Not applicable
8 years ago

Do you mean did they work a full week?

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

You should use the following formula and check if it works fine.

average=COUNTROWS(Table)/DISTINCTCOUNT(Table[Emplyeename])


Best Regards,
Angelia


  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Brilliant!