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 ID
| INC01232 | 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.