Forum Discussion

sdas028's avatar
sdas028
Helper I
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 sdas028,

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

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


    Best Regards,
    Angelia


sdas028's avatar
sdas028
Helper I
8 years ago

Do you mean did they work a full week?

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

Hi sdas028,

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

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


Best Regards,
Angelia


  • sdas028's avatar
    sdas028
    Helper I
    8 years ago

    Brilliant!