Forum Discussion
Changing team assignment solution
Hello everyone, I have the following problem when customizing my report. We already have a report that tracks the workload of our project teams. Simplified, the report consists of a project table (p...
For your reference.
Step 0: I use these data.
Step 1: I add a 'Current Team' column to the 'Project' table.
Current Team =
CALCULATE(
MAXX(
FILTER(ALL('Employee'),
'Employee'[Start Date]<=MIN('Project'[Date])
&&'Employee'[End Date]>=MIN('Project'[Date])
&&'Employee'[Employee]=MAX('Project'[Employee])
),
'Employee'[Department]),
ALLEXCEPT('Employee','Employee'[Employee])
)
Step 2: I make some 'Matrix's.