Show next milestone task for each project

[ska1903]

Hi,

I am trying to get the following information from the Project Online OData feed and struggling to figure out how to get it.

I want to show the Next task that is a milestone for each project as below.

Project -- Task

    1      -- Milestone 3

    2      -- Milestone 2

    3      -- Milestone 5

Is this possible and if so how?

Thanks 

[v-jiascu-msft]

Hi @ska1903,

What data do you have? I think you need to get the data from Project Online first. Then maybe a measure could help. Can you share a sample?

Best Regards,

Dale

[ska1903]

Hi @v-jiascu-msft, 

I am using the Project Online content pack template and I am using the OData feed for the information so all the data is available. 

My users have started 6 projects in Project Online with their associated tasks and marked some of them as milestones and now want a (supposedly) simple table showing the project name and what the next task, that is marked as a milestone, is and the date that it is supposed to Finish.

I suppose the fields I would need are;

Projects Table;

Project Name

Project ID -> realtionship to Project ID in Tasks Table

Project Owner Name

Tasks Table;

Task Name

Project ID (As above, linked)

Task is Milestone

Task Finish Date

Regards,

Mark