Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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 an...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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?