Forum Discussion
Project Online - timephase assignment attribute
Hello All, I have a Power BI connection to MS Project Online. I have successfully created numerous reports, but am struggling with this one. I have a MS Project custom column titled "Crew ID" w...
Hi Anonymous,
I am not specific about MS Project Online, you'd better share the sample data and list expected result, so that we can post detailed solution which is close to your requirement.
Best Regards,
Angelia
Hi v-huizhn-msft,
Here's the structure of my records. Each project has multiple resources assigned. Each resource has a "Crew ID" associated and specific Start/Finish dates.
| Project | Resouce | Crew ID | Start | Finish |
| Project A | Resource A | 1 | 3/5/2018 | 3/16/2018 |
| Resource B | 2 | 3/5/2018 | 3/16/2018 | |
| Resource C | 3 | 3/19/2018 | 3/30/2018 | |
| Project B | Resource D | 1 | 3/12/2018 | 3/23/2018 |
| Project C | Resource E | 1 | 3/5/2018 | 3/30/2018 |
| Resource F | 1 | 3/5/2018 | 3/30/2018 | |
| Resource G | 2 | 3/19/2018 | 4/13/2018 | |
| Resource H | 2 | 3/19/2018 | 4/13/2018 |
What I would like to accomplish is a Power BI report which lists each of the projects and a count of how many distinct Crew ID values are associated on a weekly basis. For the above, it would look like:
| 3/5/2018 | 3/12/2018 | 3/19/2018 | 3/26/2018 | 4/2/2018 | 4/9/2018 | |
| Project A | 2 | 2 | 1 | 1 | ||
| Project B | 1 | 1 | ||||
| Project C | 1 | 1 | 2 | 2 | 1 | 1 |
Does this make sense?
Thanks so much for any help you can provide!
-Stacey