Headcount Plan

Plan-versus-actual headcount, hiring, exits, cost, and scenario measures.

6 pages · Power BI

These dashboards use synthetic workforce data. Values illustrate the report design.

Choose page — 5 Projection scenarios

Selected page

5 Projection scenarios

DAX definitions

Exact source expressions and direct measure dependencies for the selected page.

Demand Headcount (Final Month)

Projection · Projection

VAR __d = MAX(Projection[monthDate]) RETURN IF(NOT HASONEVALUE(Projection[scenario]), BLANK(), CALCULATE(SUM(Projection[demandHeadcount]), KEEPFILTERS(Projection[monthDate] = __d)))

Direct dependencies: None

Gap to Demand (Final Month)

Projection · Projection

[Projected Headcount (Final Month)] - [Demand Headcount (Final Month)]

Direct dependencies: Projected Headcount (Final Month), Demand Headcount (Final Month)

Projected Exits (12 Months)

Projection · Projection

IF(NOT HASONEVALUE(Projection[scenario]), BLANK(), SUM(Projection[projectedExits]))

Direct dependencies: None

Projected Headcount (Final Month)

Projection · Projection

VAR __d = MAX(Projection[monthDate]) RETURN IF(NOT HASONEVALUE(Projection[scenario]), BLANK(), CALCULATE(SUM(Projection[projectedHeadcount]), KEEPFILTERS(Projection[monthDate] = __d)))

Direct dependencies: None

Required Hires (12 Months)

Projection · Projection

IF(NOT HASONEVALUE(Projection[scenario]), BLANK(), SUM(Projection[requiredHires]))

Direct dependencies: None