Power BI DAX

HR DAX Measures

Copy DAX measure examples for common hr KPIs used in Power BI dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

Employee Turnover Rate

Employee Turnover Rate =
DIVIDE(
    [Employees Who Left],
    [Average Employees]
)

Voluntary Turnover Rate

Voluntary Turnover Rate =
DIVIDE(
    [Voluntary Departures],
    [Average Employees]
)

Absenteeism Rate

Absenteeism Rate =
DIVIDE(
    [Absence Days],
    [Available Work Days]
)

Revenue per Employee

Revenue per Employee =
DIVIDE(
    [Revenue],
    [Employees]
)

Cost per Hire

Cost per Hire =
DIVIDE(
    [Total Recruiting Cost],
    [Number of Hires]
)

Time to Hire

Time to Hire =
DATEDIFF([Application Date], [Offer Accepted Date], DAY)

Time to Fill

Time to Fill =
DATEDIFF([Job Opened Date], [Position Filled Date], DAY)

Offer Acceptance Rate

Offer Acceptance Rate =
DIVIDE(
    [Accepted Offers],
    [Total Offers]
)

Employee Retention Rate

Employee Retention Rate =
DIVIDE(
    [Employees Remaining],
    [Employees at Start]
)

Training Cost per Employee

Training Cost per Employee =
DIVIDE(
    [Total Training Cost],
    [Employees Trained]
)

Employee Productivity

Employee Productivity =
DIVIDE(
    [Output],
    [Employee Hours]
)

Headcount Growth Rate

Headcount Growth Rate =
DIVIDE([Current Headcount] - [Previous Headcount], [Previous Headcount])

eNPS

eNPS =
[Promoter Percentage] - [Detractor Percentage]

Promotion Rate

Promotion Rate =
DIVIDE(
    [Employees Promoted],
    [Total Employees]
)