Forum Discussion
Project Completion Analysis
Hello! I am trying to build a calculation that will give me the avg days between each component of the project process. For example: In the below excel file I have project ID 1 and I want to konw th...
I would like to just know the avg days that the project sits in a specific status... I am open to ideas depending on what you are able to come up with. It would be interesting to see if it reverts back to the same status more than once what causes that. That may be another look within Power BI.
Hi nmck86,
What's your expected result? Please provide a sample of your expect result
Regards,
Jimmy Tao
Sure, I would like to see the days between each status so for project 1 there are 2 days between the WAPPR status and the Initiated status. There are also 26 days between the start of the project and the completion of the project. This is what I was trying to get to show up. Let me know if you have other questions.