How to develop resource load view like in project management software?

[Anonymous]

Hello!

I have a simple PBIX model

And I want to make a report, which can show planned effort of person per task per periods of time, like in celoxis:

I need to make a timeline table and a measure dividing filtered person hours from db_assignment on selected period.

I have made a simple PBIX, can somebody help me?

[Anonymous]

I tried to use this solution on the real data, and did not get a result.

This query joins 3 tables having count of records: db_tasks - 43,5K, db_assignments - 36,15K, dates - 3289.

ResourceLoad =
SUMMARIZE(
filter(
CROSSJOIN(db_assignment, db_task, Local_DateTime),
db_assignment[task_id]==db_task[id]
&& Local_DateTime[Date]>=db_task[planned_start].[Date]
&& Local_DateTime[Date]<=db_task[planned_finish].[Date]
&& NOT(Local_DateTime[IsHolidayInRussia])
),
db_assignment[user_id], db_task[id], Local_DateTime[Date], "_plan", sum(db_assignment[DailyHours]), "_days",count(db_task[Duration])
)

It always stucks at calculating table.

May be there is a better way to make this join?

[Anonymous · Accepted solution]

Thank you, but I ment I need Matrix form of resource load.

I've found an example! Thanks to @amitchandak 🙂

My refined example here

[Anonymous]

Hi @Anonymous ,

I have updated your pbix file to create a Gantt visual based on the data in it as shown below. Please download the attachment later to see if what's inside is what you want.

Best Regards