Forum Discussion

ElieK's avatar
ElieK
Icon for Helper I rankHelper I
6 years ago
Solved

Historical Employee Productivity over time

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, a...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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.

     

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    ElieK
    Icon for Helper I rankHelper I
    6 years ago

    Thanks! This worked perfectly!