Historical Employee Productivity over time

Question

Hello,&nbsp;I've been trying to figure out a way to easily track Employee Productivity over a period of time.We might have employees work on one (or two) line(s) of the bussiness for a few months, and then move on to another line of the bussiness, as is the contact centre life.I could formulate an excel file that feeds into PowerBI to assign them teams, but I am struggling with figuring out how to retain the hisotical work of that Employee after they move to work on another line of work.&nbsp;ExampleNameWeek StartingDepartment ADepartment BDepartment CDepartment DEmployee A13-OCT-2019YesNoNoNoEmployee B13-OCT-2019NoYesNoNoEmployee C13-OCT-2019NoYesNoNoEmployee D13-OCT-2019NoNoYesNoEmployee E13-OCT-2019NoNoYesNoEmployee F13-OCT-2019NoNoNoYesEmployee G13-OCT-2019YesNoNoNoEmployee A20-OCT-2019NoYesNoNoEmployee B20-OCT-2019YesNoNoNoEmployee C20-OCT-2019YesNoNoNoEmployee D20-OCT-2019NoYesYesNoEmployee E20-OCT-2019NoNoNoYesEmployee F20-OCT-2019NoNoNoYesEmployee G20-OCT-2019NoNoYesNo&nbsp;Any insight on how I can see the Prouctivity of Employee A over this period would be great.Is there a way to have PowerBI refer to a specific Date and then pull the work that employee did?&nbsp;I would need to be able to scale this to track ~170 Employees, and Assignments could change on a weekly bassis (rarely but they do happen)&nbsp;Hopefully this makes sense&nbsp;Thanks,Elie

v-eachen-msft · Accepted Answer

Hi&nbsp;ElieK&nbsp;,
&nbsp;
At first, you need to unpivot department columns in the query editor.
Then you could create a measure to show the data.
Measure =
CONCATENATEX (
    FILTER ( 'Table', 'Table'[Value] = "Yes" ),
    'Table'[Attribute],
    ","
)
Here is the result.
&nbsp;

&nbsp;

Forum Discussion

Historical Employee Productivity over time

2 Replies

Related content

Visualizing Historical Data

Historical Log support

Missing employee

Counting Active employees per month

Exchange Rates - Historical

Name	Week Starting	Department A	Department B	Department C	Department D
Employee A	13-OCT-2019	Yes	No	No	No
Employee B	13-OCT-2019	No	Yes	No	No
Employee C	13-OCT-2019	No	Yes	No	No
Employee D	13-OCT-2019	No	No	Yes	No
Employee E	13-OCT-2019	No	No	Yes	No
Employee F	13-OCT-2019	No	No	No	Yes
Employee G	13-OCT-2019	Yes	No	No	No
Employee A	20-OCT-2019	No	Yes	No	No
Employee B	20-OCT-2019	Yes	No	No	No
Employee C	20-OCT-2019	Yes	No	No	No
Employee D	20-OCT-2019	No	Yes	Yes	No
Employee E	20-OCT-2019	No	No	No	Yes
Employee F	20-OCT-2019	No	No	No	Yes
Employee G	20-OCT-2019	No	No	Yes	No