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 and a measure dividing filtered person hours from db_assignment on selected period.

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

 

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

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

    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

  • 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?