Historical Employee Productivity over time

[ElieK]

Hello,

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.

Example

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

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?

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)

Hopefully this makes sense

Thanks,

Elie

[v-eachen-msft · Accepted solution]

Hi @ElieK ,

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.

[ElieK]

Thanks! This worked perfectly!