What it measures
% of new hires leaving within 12 months
it measures retention failures that have already occurred. The costs of recruitment, training, and lost productivity are already sunk by the time the rate is calculated for a 12-month cohort.
Business impact
- A sustained high rate creates a permanent 'chaos tax' of agency labor spend, overtime for remaining staff, and constant supervisory intervention to manage inexperienced teams.
- The operational drag of a constantly churning workforce directly impacts labor or line capacity, leading to lower throughput, more quality deviations, and a weakened inventory position on key SKUs.
Formula
(New hires leaving <1 year / Total new hires) x 100Grain
One row per employee per month — site × cost_center × hire_date
Inside the Implementation Pack
A preview of what's actually built for this KPI — extracted from the real Implementation Pack, not a mockup.
This is the primary ratio the pack's other measures build on — trend, rank, and period-comparison variants, all on Fact_Employee_Snapshot.
Fact_Employee_Snapshot— 8 mandatory columns — early termination count, period key, ...Dim_Cost_Center— key + nameDim_Employee— key + nameDim_Period— key + nameDim_Plant— key + nameDim_Site— key + nameDim_Date— Auto-generated calendar table — no customer data required
Full field-by-field data contract, in 4 SQL dialects (SQL Server, Snowflake, Databricks, BigQuery), ships in the pack.
| Target | 0.2 — performance considered compliant at or below this line |
| Warning | 0.35 — amber alert — triggers a review |
Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.
Everything you need to build Early Turnover Rate in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.