November 5, 2020, 8:30 a.m. to 6 p.m. EDT | November 6, 2020 – February 7, 2021, On-Demand | Online Conference
Please login or join to subscribe to this thread
You should be able to do that in a couple of ways in tools like MS Project or Primavera P6.
In MS Project you could setup your schedule of activities including all the milestones with their planned start/finish dates.
Navigate to the Project menu and select Set Baseline and click OK
That copies your original milestone dates into a separate set of baseline date fields. You can then update your actual progress including any date changes on your activities and get a visual on your Gantt chart view of any slippage. You can filter your Gantt to just show the milestones too.
You could then save a baseline at the end of each period (month, quarter etc.) and it'll save those dates into Baseline 2, 3, 4 etc.
Then setup a custom tracking report showing all the milestone date fields, even export it to Excel if you want.
Desktop version of MS Project restricts you to a maximum of 10 baselines but if you're using MS Project Server version or Primavera P6 you don't have that restriction.
If you're already using the Baseline date fields to track the original contract dates on a commercial project for instance, there's another way you could do it and still get the same results out.
MS Project lets you save an interim version of your plan which does essentially the same as baselining but saves the dates into Interim Plan 1, Interim plan 2 etc. date fields. Setup a custom report and then you're good to go. Same caveat on the desktop version of MS Project though with a maximum of 10 interim plans.
Primavera does essentially the same thing too but it's called PEND (Period end reporting)
Majority of these scheduling tools will do mostly anything you could possibly want if you know scheduling and how to navigate around the tool.
Hope that helps.
I work for iCoTech Services (https://icotechservices.co.uk) and we can provide customised applications that are fully tailored to your needs. We also offer a pre-configured PowerApp (iCoPlan) with PowerBI to support your reporting.
Drop me a line if you would like to chat further about how we can help you.
Please login or join to reply