Baseline saving % progress

%3CLINGO-SUB%20id%3D%22lingo-sub-1559478%22%20slang%3D%22en-US%22%3EBaseline%20saving%20%25%20progress%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559478%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3CBR%20%2F%3EMy%20organization%20uses%20project%20and%20powerBI%20as%20tools%20of%20PMO.%3CBR%20%2F%3EI'm%20responsible%20for%20BI%20Dashboards%20and%20i%20need%20to%20show%20the%20progress%20of%20some%20projects%20since%20last%20week.%20I%20see%20the%20best%20and%20maybe%20only%20way%20to%20do%20this%20is%20saving%20baselines%20at%20project%20and%20then%20comparing%20them%20at%20my%20dashboard%2C%20but%20baselines%20only%20save%20few%20informations%20like%20FinishDate%2C%20Cost%2C%20Duration%2C%20Work...%20How%20can%20save%20progress%20using%20baselines%3F%20There%20is%20any%20setting%20to%20do%20it%3F%3CBR%20%2F%3EWhat%20i%20want%20is%20like%20this%3A%3CBR%20%2F%3EProject%20A%20Progress%2050%25%20at%20Date%20A%20(Baseline%201)%3CBR%20%2F%3EProject%20A%20Progress%2075%25%20at%20Date%20B%20(Baseline%202)%3CBR%20%2F%3EAny%20way%20to%20do%20this%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561802%22%20slang%3D%22en-US%22%3ERe%3A%20Baseline%20saving%20%25%20progress%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561802%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746344%22%20target%3D%22_blank%22%3E%40BrunoErhardt%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EYou%20will%20need%20a%20data%20snapshot%20type%20solution.%20I%20have%20a%20blog%20post%20with%20a%20solution%20starter%20example%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpwmather.wordpress.com%2F2018%2F12%2F14%2Fprojectonline-snapshot-data-to-sharepoint-list-using-msflow-microsoftflow-ppm-pmot-office365-powerplatform%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpwmather.wordpress.com%2F2018%2F12%2F14%2Fprojectonline-snapshot-data-to-sharepoint-list-using-msflow-microsoftflow-ppm-pmot-office365-powerplatform%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20what%20you%20describe%2C%20if%20you%20started%20with%20the%20example%20in%20the%20post%20you%20would%20need%20to%20add%20in%20the%20%25%20complete%20field.%20You%20might%20also%20want%20to%20store%20the%20snapshot%20data%20in%20to%20another%20source%20such%20as%20Azure%20SQL%20database%20or%20CDS%20etc.%20rather%20than%20SharePoint%20lists%20-%20it%20really%20depends%20how%20much%20data%20you%20will%20end%20up%20storing.%3C%2FP%3E%0A%3CP%3EHope%20that%20helps%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello everyone,
My organization uses project and powerBI as tools of PMO.
I'm responsible for BI Dashboards and i need to show the progress of some projects since last week. I see the best and maybe only way to do this is saving baselines at project and then comparing them at my dashboard, but baselines only save few informations like FinishDate, Cost, Duration, Work... How can save progress using baselines? There is any setting to do it?
What i want is like this:
Project A Progress 50% at Date A (Baseline 1)
Project A Progress 75% at Date B (Baseline 2)
Any way to do this? Thanks

1 Reply
Highlighted

Hello @BrunoErhardt ,

You will need a data snapshot type solution. I have a blog post with a solution starter example here: https://pwmather.wordpress.com/2018/12/14/projectonline-snapshot-data-to-sharepoint-list-using-msflo... 

From what you describe, if you started with the example in the post you would need to add in the % complete field. You might also want to store the snapshot data in to another source such as Azure SQL database or CDS etc. rather than SharePoint lists - it really depends how much data you will end up storing.

Hope that helps

Paul