Turnover cohorts and 12-month survival in DAX
Move beyond the annual turnover ratio: cohort retention curves, early-leaver rates and a BDA-compliant turnover measure in one model.
Power BI07 Turnover and retentionExpert31 min
The recording for this walkthrough is being published — the files below already contain the full model.
What you will build
- 01Model entries and exits against a single date table
- 02Write turnover measures (BDA, Schlüter, ZVEI) side by side
- 03Build a cohort matrix with a disconnected months-since table
Dataset used
Five years of hires and leavers with reason codes and manager hierarchy.