Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |