Forum Discussion
Average Weekly Attendance based upon working days
Hi,
I am trying to get an average weekly attendance based upon the number of working days in that week instead of default 5, but not getting the solution to dynamically divide to calculate average.
I have 2 tables -
Table 1 - Attendance Table, where I have a date, employeeId (if emplyee came), weeknum (calendar weekNum calculated from date).
Table 2 - Week WorkingDays table, where I simply have weekNum and working days in that week.
Now, if in week 1, count of employeeid is 500 and week1 has 5 working days, my week1 average should be 500/5 = 100
and if in week 2, count of employeeid is 450 and week2 has 4 working days, my week2 average should be 450/4 = 112.5
I am calculating the week wise total attendance by a measure
How to do this?
1 Reply
- lbendlinSuper User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523