Absence rate that survives partial months
Explode absence intervals into calendar days in Power Query, then report a target-hours based absence rate that reconciles with the time system.
Excel (advanced)05 Attendance and sicknessAdvanced24 min
The recording for this walkthrough is being published — the files below already contain the full model.
What you will build
- 01Split date ranges into days with List.Dates
- 02Separate calendar days from working days
- 03Handle absences that cross the month boundary
Dataset used
18 months of absence intervals with absence type and a working-time calendar.