Forum Discussion
Performance Calculations
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 |
- Hi,
Has this been resolved?
Rgds,
Vivek
2 Replies
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.
- Hi,
Has this been resolved?
Rgds,
Vivek