Forum Discussion
Weekly average headcount
I'm in a conundrum. I want to see the average amount of employees available per month. I made calculated table that looks like this: Weeknum WeekDay Number of employees 2018 Week 39 2 Mon...
Hi Anonymous
Create measures
average = var count1 = CALCULATE(DISTINCTCOUNT('date Table'[weeknum]),ALLSELECTED('date Table')) return DIVIDE([Number of Employees],count1)If you want the following result
WeekDay sum of Employees average of Employees 2 Monday 30 30/4 3 Tuesday 39 39/4 4 Wednesday 30 30/4 5 Thursday 44 44/4 6 Friday 25 25/3 Friday (only occurs three times in table above)
create measures as below
average2 = AVERAGEX(FILTER(SUMMARIZE('date Table','date Table'[Date],'date Table'[weeknum],[weekday]),[Measure]=1),[Number of Employees])Best Regards
Maggie
A given calendar week can have days that fall in different months.
You data doesn't have a date column nor a month column. So there's no way to calculate the average for a month
The data I put there comes from the graphs that I have. due to the GDPR laws, I dont want to share too much information on the company, but I'll mask it. see table below:
NumberOpenedOpened ByCaller IDINC01232 18/10/2018 9407156 9407156 INC01233 18/10/2018 9406682 9401567 INC01234 18/10/2018 9406720 9770478 INC01235 18/10/2018 9770639 9770639 INC01236 18/10/2018 9770327 9770327 INC01237 18/10/2018 9900435 9770289 INC01238 18/10/2018 9406322 9006419 INC01239 18/10/2018 9322356 9322356 INC01240 18/10/2018 9900435 9312888 INC01241 18/10/2018 9770478 9770478 INC01242 18/10/2018 9406322 9404822 INC01243 18/10/2018 9770095 9770095 INC01244 18/10/2018 9404861 9009531 INC01245 18/10/2018 9022088 9022088 This is linked with a date table.
The date table does include weeknumber, day, weekday, month, year etc.