Project Dashboard Template for Construction & Engineering Project Managers — Earned Value (CPI, SPI, EAC) in Power BI

Map your own schedule export onto 3 tables and refresh: 8 DAX measures compute CPI, SPI, Cost Variance, EAC and VAC across 3 report pages and 17 visuals. The file carries no data — yours goes in. Publishing the result to a team needs a Power BI Pro seat at Microsoft's list price of US$14 per user per month (US$168 per user per year), so the earned-value maths behind the numbers your board sees has to be right before you share it.

Measures included (DAX) (8)

Cost Performance Index (CPI) (Table: Tasks)

DAX: DIVIDE(SUM('Tasks'[BCWP Earned Value]), SUM('Tasks'[ACWP Actual Cost]))

Uses: 'Tasks'[BCWP Earned Value], 'Tasks'[ACWP Actual Cost]

Format: 0.00

Schedule Performance Index (SPI) (Table: Tasks)

DAX: DIVIDE(SUM('Tasks'[BCWP Earned Value]), SUM('Tasks'[BCWS Planned Value]))

Uses: 'Tasks'[BCWP Earned Value], 'Tasks'[BCWS Planned Value]

Format: 0.00

Cost Variance (Table: Tasks)

DAX: SUM('Tasks'[BCWP Earned Value]) - SUM('Tasks'[ACWP Actual Cost])

Uses: 'Tasks'[BCWP Earned Value], 'Tasks'[ACWP Actual Cost]

Format: #,##0

Estimate at Completion (Table: Tasks)

DAX: DIVIDE(SUM('Tasks'[Baseline Cost]) * SUM('Tasks'[ACWP Actual Cost]), SUM('Tasks'[BCWP Earned Value]))

Uses: 'Tasks'[Baseline Cost], 'Tasks'[ACWP Actual Cost], 'Tasks'[BCWP Earned Value]

Format: #,##0

Variance at Completion (Table: Tasks)

DAX: SUM('Tasks'[Baseline Cost]) - DIVIDE(SUM('Tasks'[Baseline Cost]) * SUM('Tasks'[ACWP Actual Cost]), SUM('Tasks'[BCWP Earned Value]))

Uses: 'Tasks'[Baseline Cost], 'Tasks'[ACWP Actual Cost], 'Tasks'[BCWP Earned Value]

Format: #,##0

Average Milestone Slip (Days) (Table: Milestones)

DAX: AVERAGE('Milestones'[Slip Days])

Uses: 'Milestones'[Slip Days]

Format: 0.0

Issue Count (Table: Issues)

DAX: COUNTROWS('Issues')

Format: 0

Average Days Open (Table: Issues)

DAX: AVERAGE('Issues'[Days Open])

Uses: 'Issues'[Days Open]

Format: 0.0

Columns your data must have (23)

Tasks

Column	Type	Summarize by
`Project Name`	string
`Task Name`	string
`Phase`	string
`Status`	string
`Finish`	dateTime
`Percent Complete`	double
`Baseline Cost`	decimal
`BCWS Planned Value`	decimal
`BCWP Earned Value`	decimal
`ACWP Actual Cost`	decimal

Header row: Project Name,Task Name,Phase,Status,Finish,Percent Complete,Baseline Cost,BCWS Planned Value,BCWP Earned Value,ACWP Actual Cost

Milestones

Column	Type	Summarize by
`Project Name`	string
`Milestone Name`	string
`Owner`	string
`Baseline Date`	dateTime
`Forecast Date`	dateTime
`Slip Days`	int64

Header row: Project Name,Milestone Name,Owner,Baseline Date,Forecast Date,Slip Days

Issues

Column	Type	Summarize by
`Project Name`	string
`Issue Key`	string
`Summary`	string
`Priority`	string
`Status`	string
`Created`	dateTime
`Days Open`	int64

Header row: Project Name,Issue Key,Summary,Priority,Status,Created,Days Open

Report pages (3)

Portfolio Health (EVM) — Visuals (6): Cost Performance Index (CPI), Schedule Performance Index (SPI), Estimate at Completion (EAC), Variance at Completion (VAC), Cost Variance by Phase, Project
Schedule & Milestone Slip — Visuals (5): Average Milestone Slip (Days), Slip Days by Milestone, CPI by Task Finish Date, Milestone Register, Milestone Owner
Issue & Risk Load — Visuals (6): Issues in Scope, Average Days Open, Issues by Priority, Issues by Status, Issue Register, Project

Get the complete version $69

This page is the working piece. The full pack has everything below.

검로드 1리스팅 · 5개국어 상세 · ★소유 · 전체 깊이 · 오프라인 · 기계가 먹는 파일 · 가격=⛔상수 금지 — ★측정된 경쟁 밴드(L4)

Send it to me