
What you get: This page is the working piece.
Your team already pays $14 per user/month for Power BI Pro (Microsoft list price effective 1 April 2025) and it still opens on an empty canvas. Point this at your cost report, your P6/MS Project export and your RFI register, hit Refresh, and read CPI, SPI, Forecast at Completion, worst float and overdue RFIs on three pages.
DAX: DIVIDE(SUM('Cost Ledger'[Earned Value]), SUM('Cost Ledger'[Actual Cost to Date]))
Uses: 'Cost Ledger'[Earned Value], 'Cost Ledger'[Actual Cost to Date]
Format: 0.00
DAX: DIVIDE(SUM('Cost Ledger'[Earned Value]), SUM('Cost Ledger'[Planned Value]))
Uses: 'Cost Ledger'[Earned Value], 'Cost Ledger'[Planned Value]
Format: 0.00
DAX: DIVIDE(SUM('Cost Ledger'[Original Budget]) + SUM('Cost Ledger'[Approved Change Orders]), DIVIDE(SUM('Cost Ledger'[Earned Value]), SUM('Cost Ledger'[Actual Cost to Date])))
Uses: 'Cost Ledger'[Original Budget], 'Cost Ledger'[Approved Change Orders], 'Cost Ledger'[Earned Value], 'Cost Ledger'[Actual Cost to Date]
Format: #,##0
DAX: SUM('Cost Ledger'[Original Budget]) + SUM('Cost Ledger'[Approved Change Orders]) - SUM('Cost Ledger'[Committed Cost])
Uses: 'Cost Ledger'[Original Budget], 'Cost Ledger'[Approved Change Orders], 'Cost Ledger'[Committed Cost]
Format: #,##0
DAX: AVERAGE('Schedule Tasks'[Finish Variance Days])
Uses: 'Schedule Tasks'[Finish Variance Days]
Format: 0.0
DAX: MIN('Schedule Tasks'[Total Float Days])
Uses: 'Schedule Tasks'[Total Float Days]
Format: 0
DAX: SUM('Open Items'[Is Overdue])
Uses: 'Open Items'[Is Overdue]
Format: 0
DAX: SUM('Open Items'[Cost Impact])
Uses: 'Open Items'[Cost Impact]
Format: #,##0
| Column | Type | Summarize by |
|---|---|---|
Project Name | string | |
Cost Code | string | |
Work Package | string | |
Period End Date | dateTime | |
Original Budget | decimal | |
Approved Change Orders | decimal | |
Committed Cost | decimal | |
Actual Cost to Date | decimal | |
Earned Value | decimal | |
Planned Value | decimal |
Header row: Project Name,Cost Code,Work Package,Period End Date,Original Budget,Approved Change Orders,Committed Cost,Actual Cost to Date,Earned Value,Planned Value
| Column | Type | Summarize by |
|---|---|---|
Project Name | string | |
Activity ID | string | |
Activity Name | string | |
Baseline Finish | dateTime | |
Forecast Finish | dateTime | |
Total Float Days | int64 | |
Finish Variance Days | int64 | |
Percent Complete | double | |
Is Critical | int64 |
Header row: Project Name,Activity ID,Activity Name,Baseline Finish,Forecast Finish,Total Float Days,Finish Variance Days,Percent Complete,Is Critical
| Column | Type | Summarize by |
|---|---|---|
Project Name | string | |
Item Type | string | |
Reference | string | |
Date Raised | dateTime | |
Response Due Date | dateTime | |
Days Open | int64 | |
Is Open | int64 | |
Is Overdue | int64 | |
Cost Impact | decimal |
Header row: Project Name,Item Type,Reference,Date Raised,Response Due Date,Days Open,Is Open,Is Overdue,Cost Impact
This page is the working piece. The full pack has everything below.
Your team already pays $14 per user/month for Power BI Pro (Microsoft list price effective 1 April 2025) and it still opens on an empty canvas. Point this at your cost report, your P6/MS Pro
Microsoft's published list price is $14 per user/month for Power BI Pro and $24 per user/month for Premium Per User, both effective 1 April 2025. The licence is already bought — what is missing is the model that sits on it. This t
Buy the full version — $69Need more than this one? ReadyStack Pass opens all 679 files and 561 full versions — $29/month or $199/year. See the Pass →
Your team already pays $14 per user/month for Power BI Pro (Microsoft list price effective 1 April 2025) and it still opens on an empty canvas.
The preview on this page is free. The full version ($69) adds: This page is the working piece.
1. Look at the preview of the file below. 2. Pay once and download the file right away. 3. Open it and fill in your own details.
One question, answered by the person who built it. Your email only if you want the answer sent.
For a team or company: for an invoice with your company details, a quote or several licences, write to support@getreadystack.com.
ReadyStack is a small team. We build each tool for one job people keep asking about, from the rules and sources named on the page, and we run it on the worked example you see here before it goes live.
How we check our pages: each rule names its source and the day we read it.
Something looks wrong, or you are stuck? Write to support@getreadystack.com or use the contact form. It goes to our own inbox, not to a bot.
ReadyStack
Calculators, templates and deadlines for the rules that change every year — free in your browser.