Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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...
Need Help
Newbie1's avatar
Newbie1
Frequent Visitor
8 years ago

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello,

 

I am pulling the Project name and dates from [AssignmentTimephasedDataSet] and the Crew ID from [Assignments]. 

 

Thank you,

 

-Stacey

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.  However, it is giving the count of distinct crews across all projects, rather than by each project (see below).

     

    • Newbie1's avatar
      Newbie1
      Frequent Visitor
      8 years ago

      Unfortunately, I dont have access to those tables at my end. Have you tried using Resourcedemanddata table along with matrix visualization. It seems to have all information like day, project name and resource.