Hi all
This is my first post, so apologies if it is long-winded or makes no sense!
I am looking to create a dashboard which shows how much work is done by staff members, by team.
I have managed to create a hierarchy, using the 'Path' and 'PathItem' DAX functions but, am now wondering whether there is a way in which to incorporate staff start and end dates within teams so that if a staff member moves teams midway through a reporting cycle their work would be attributed to the correct team.
E.g.
John starts working for team 1 on 1/1/2016 and during his time there completes 150 pieces of work
John then moves to team 2 on 14/2/2016 and completes another 150 pieces of work
When doing a quarterly report, I want to show the 150 items for team 1 and then the 150 for team 2
Many thanks
This is my first post, so apologies if it is long-winded or makes no sense!
I am looking to create a dashboard which shows how much work is done by staff members, by team.
I have managed to create a hierarchy, using the 'Path' and 'PathItem' DAX functions but, am now wondering whether there is a way in which to incorporate staff start and end dates within teams so that if a staff member moves teams midway through a reporting cycle their work would be attributed to the correct team.
E.g.
John starts working for team 1 on 1/1/2016 and during his time there completes 150 pieces of work
John then moves to team 2 on 14/2/2016 and completes another 150 pieces of work
When doing a quarterly report, I want to show the 150 items for team 1 and then the 150 for team 2
Many thanks