Connect to multiple baselines in MS Project

[Matt22365]

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

[Matt22365 · Accepted solution]

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