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 — 1 Plan summary

Selected page

1 Plan summary

DAX definitions

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

Actual Cost

HcPlan · Cost

SUM(HcPlan[actualCostUsd])

Direct dependencies: None

Actual Headcount

HcPlan · Headcount

VAR __d = MAXX(FILTER(HcPlan, NOT ISBLANK(HcPlan[actualHeadcount])), HcPlan[monthDate]) RETURN IF(ISBLANK(__d), BLANK(), CALCULATE(SUM(HcPlan[actualHeadcount]), KEEPFILTERS(HcPlan[monthDate] = __d)))

Direct dependencies: None

Actual Hires

HcPlan · Flows

SUM(HcPlan[actualHires])

Direct dependencies: None

Cost Variance

HcPlan · Cost

IF(ISBLANK([Actual Cost]), BLANK(), [Actual Cost] - [Planned Cost (Actual Months)])

Direct dependencies: Actual Cost, Planned Cost (Actual Months)

Cost Variance %

HcPlan · Cost

DIVIDE([Cost Variance], [Planned Cost (Actual Months)])

Direct dependencies: Cost Variance, Planned Cost (Actual Months)

Headcount Variance

HcPlan · Headcount

IF(ISBLANK([Actual Headcount]), BLANK(), [Actual Headcount] - [Planned Headcount (at Actual Month)])

Direct dependencies: Actual Headcount, Planned Headcount (at Actual Month)

Hiring Attainment

HcPlan · Flows

DIVIDE([Actual Hires], [Planned Hires (Actual Months)])

Direct dependencies: Actual Hires, Planned Hires (Actual Months)

Planned Cost (Actual Months)

HcPlan · Cost

CALCULATE(SUM(HcPlan[plannedCostUsd]), KEEPFILTERS(HcPlan[phase] = "Actual"))

Direct dependencies: None

Planned Headcount (at Actual Month)

HcPlan · Headcount

VAR __d = MAXX(FILTER(HcPlan, NOT ISBLANK(HcPlan[actualHeadcount])), HcPlan[monthDate]) RETURN IF(ISBLANK(__d), BLANK(), CALCULATE(SUM(HcPlan[plannedHeadcount]), KEEPFILTERS(HcPlan[monthDate] = __d)))

Direct dependencies: None

Planned Hires (Actual Months)

HcPlan · Flows

CALCULATE(SUM(HcPlan[plannedHires]), KEEPFILTERS(HcPlan[phase] = "Actual"))

Direct dependencies: None