Project Online - timephase assignment attribute

Question

Hello All,&nbsp;I have a Power BI connection to MS Project Online.&nbsp; I have successfully created numerous reports, but am struggling with this one.&nbsp; I have a MS Project custom column titled "Crew ID" with numerical values (1, 2, 3, 4, etc).&nbsp; Each assignment has a Crew ID value designated.&nbsp; This is so that we can see which individuals are affiliated as a crew.&nbsp; I would like to add a Power BI report which is timephased showing how many crews we have deployed on a weekly basis.&nbsp; I have created timephased reports of resource&nbsp;work, but have been unable to use the distinct count of the crew ID as the table value.&nbsp; Does anyone have a suggestion?&nbsp;Thanks,&nbsp;Stacey

v-huizhn-msft · Answer

Hi&nbsp;Anonymous,I am not specific about&nbsp;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

anonymous · Answer

Hi&nbsp;v-huizhn-msft,&nbsp;Here's the structure of my records.&nbsp; Each project has multiple resources assigned.&nbsp; Each resource has a "Crew ID" associated and specific Start/Finish dates.&nbsp;ProjectResouceCrew IDStartFinishProject AResource A13/5/20183/16/2018&nbsp;Resource B23/5/20183/16/2018&nbsp;Resource C33/19/20183/30/2018Project BResource D13/12/20183/23/2018Project CResource E13/5/20183/30/2018&nbsp;Resource F13/5/20183/30/2018&nbsp;Resource G23/19/20184/13/2018&nbsp;Resource H23/19/20184/13/2018&nbsp;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.&nbsp; For the above, it would look like:&nbsp;&nbsp;3/5/20183/12/20183/19/20183/26/20184/2/20184/9/2018Project A2211&nbsp;&nbsp;Project B&nbsp;11&nbsp;&nbsp;&nbsp;Project C112211&nbsp;Does this make sense?&nbsp;Thanks so much for any help you can provide!&nbsp;-Stacey

newbie1 · Answer

Please provide the name of the tables you are using in Project online while attempting the solution.

anonymous · Answer

Hello,&nbsp;I am pulling the Project name and dates from [AssignmentTimephasedDataSet] and the Crew ID from [Assignments].&nbsp;&nbsp;Thank you,&nbsp;-Stacey

anonymous · Answer

I have attempted to create this as a Matrix with the Project Name for the rows, week beginning date for the columns, and DistinctCount of Crew ID's as the values.&nbsp; However, it is giving the count of distinct crews across all projects, rather than by each project (see below).&nbsp;

Forum Discussion

Project Online - timephase assignment attribute

6 Replies

Related content

Assign attributes randomly

Timephased Data Resource Planning

Order attributes

Attribute Slicer Continuation

Priority Based Sales Rep Assignment

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