Forum Discussion

Matt22365's avatar
Matt22365
Resolver III
8 years ago
Solved

Connect to multiple baselines in MS Project

Hi

 

I hope someone can help

 

I am attempting to create a report in BI which shows the change of a project though its life. To do this I will need to access all of the previous baselines and their respective variences. Is this possible?

 

I know that the current duration varience is based on what ever the active baseline is set to in MSP so i assume i will need calculated columns to work aout the varience between e.g. baseline 1, baseline 2 etc... However I am not sure how to show all the baselines, rather than just the active one

 

Thanks for your help

 

Matt

Need Help
  • Matt22365's avatar
    Matt22365
    8 years ago

    I found a way round the issue, I created new calculated fields in the source data creating new variance columns for each baseline. This then translates down into BI

     

    Thanks

     

    Matt

1 Reply

  • Matt22365's avatar
    Matt22365
    Resolver III
    8 years ago

    I found a way round the issue, I created new calculated fields in the source data creating new variance columns for each baseline. This then translates down into BI

     

    Thanks

     

    Matt