DAX Attrition Rate Measure

Notes

Depends on the Terminations and Headcount (End of Period) measures from this library.

Requirements

• The Terminations and Headcount (End of Period) measures.

Builds on these measures

• TerminationsCounts employees whose termination date falls within the current filter context.
• Headcount (End of Period)Counts active employees as of the last date in the current filter context, a semi-additive measure.

How to use this measure

1. In Power BI Desktop, select the table that should hold the measure and choose New measure on the ribbon.
2. Paste the code, then replace the placeholder table and column names with your own. The My table names fields above do this for you.
3. Run it through the DAX Formatter if you want it laid out in your team's style.

Related DAX measures

• Headcount (End of Period)Counts active employees as of the last date in the current filter context, a semi-additive measure.
• TerminationsCounts employees whose termination date falls within the current filter context.
• Absenteeism RateExpresses days absent as a percentage of total scheduled working days.
• Utilization %Expresses billable or productive hours as a percentage of total available hours.
• Average TenureAverages how many years each active employee has been with the company.
• New HiresCounts employees whose hire date falls within the current filter context.

More DAX resources

Browse all 175 measures in the Power BI DAX Measures Library, or search the library for something similar to Attrition Rate.