Performance Calculations

[Anonymous]

Hello,

I need some help creating performance calculations/project health metrics on my dashboard. I have a list of projects with scheduled start and end dates, and associated actual start and end dates. I need measures for how we are performing agaisnst the schedule (are we behind, on time, or ahead of schedule for each task). Any ideas would be helpful! Below is a sample excel document with the information. Thank you for your time and consideration!

District	Task	Start Date	End Date	Duration	Actual Start	Actual End	Today
Oregon	Actual Timeline	3/12/2019	8/10/2019	151			7/12/2019
Oregon	Go Live	7/17/2019	7/17/2019	0			7/12/2019
Oregon	Discovery	3/19/2019	3/19/2019	0	3/13/2019	3/13/2019	7/12/2019
Oregon	Asset Hierarchy	3/19/2019	6/17/2019	90	3/21/2019	6/20/2019	7/12/2019
Oregon	OMS Activity to Maximo Migration	7/10/2019	7/10/2019	0	7/10/2019	7/10/2019	7/12/2019
Oregon	Training Complete	7/24/2019	7/24/2019	0			7/12/2019
Oregon	On Site Support Start	7/25/2019	8/17/2019	23			7/12/2019

[vivran22 · Accepted solution]

Hi,

Has this been resolved?

Rgds,
Vivek

[vivran22]

@Anonymous 

Hi,

The exact requirement in terms of output is not clear from the description, however you may refer to the pbix file here

Rgds,

Vivek

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.