Turnover in 2025

An employee is on the payroll at a date when HireDate is on or before it and LastWorkingDay is blank or after it. Turnover = leavers in 2025 (FactExit) / average of the twelve month-end headcounts of 2025. What percentage? 2 decimals.

Expected: One percentage, 2 decimals · KPI card
Tables: FactExit, DimEmployee · columns

FactExit
DimEmployee

LastWorkingDay
HireDate
Topics: Time Series & Trends KPI & Executive Reporting Workforce & Payroll

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

Join the discussion

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in