Task report

[Anonymous]

Hi all,

Again apologies for what is probably a really simple query.

I'm planning on creating a report that includes upcoming and overdue tasks. At the moment I have the Project Owner showing in the table, but that isn't any good for me as there will be times tasks are assigned to other people other than the owner, so I want to show the task and the assigned resource. Doing a search others have mentioned using the resourceid column, but in my Tasks table I have no such column. I'm also trying to figure out how to identify the inactive tasks but again no luck so far. Can anyone point me in the right direction please?

Thanks.

[v-frfei-msft]

Hi @Anonymous ,

As your description, Creating a calculated column or custom column should help you. Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Anonymous · Accepted solution]

Apologies for the delayed response. I figured out where I was going wrong. I had forgotten I had a filter in place at the query level and the inactive tasks that were showing were ones that still had a resource assigned. So all sorted.

[adambhappy]

This question doesn't seem related to Power BI but rather the specific task management/project management system you are using?

[Anonymous]

Hi Adam,

Apologies I probably should have been a little clearer. I am creating the report in Power BI connected to my Project Web App data source.