How is PPC calculated in the Power BI dashboard?
If you've downloaded one of our free Power BI dashboards, then you may have questions about how the PPC (percent plan complete) is being calculated.
Here's a quick summary:
The PPC of a task is the percentage of the days of planned work that happened between last week and now (or any two publication dates).
Example:
If you had three tasks;
Task A - 3-day tasks all planned to occur in the reference week
Task B - 2-day task all planned to occur in the reference week
Task C - 4-day task with two days planned in the reference week and two days the following week
With these outcomes;
Task A - all three days occurred during the reference week
Task B - slipped, and one of the days occurred in the reference week
Task C - slipped, and one of the days occurred in the reference week
Task A - 3 / 3 days = 100% PPC
Task B - 1 / 2 days = 50% PPC
Task C - 1 / 2 days = 50% PPC
So your total PPC would be AVERAGE(A, B and C) = 66%
Last updated