Forum Discussion

damian_bell's avatar
damian_bell
Frequent Visitor
5 years ago
Solved

Linking table values

Hi,  I would like to report the performance of employees against a number of criteria. The data source is Excel table called Performance, example below:     Season Criteria X Criteria Y Cri...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    damian_bell,

     

    Try this solution.

     

    1. In Power Query, unpivot the Criteria columns by selecting the three Criteria columns, then right-click and select Unpivot Columns. Rename the Attribute column as Criteria.

     

     

    2. Create relationship:

     

     

    3. Create calculated column in Performance table:

     

    Rating Index = RELATED ( Rating[RatingIndex] )

     

    4. Result:

     

     

damian_bell's avatar
damian_bell
Frequent Visitor
5 years ago

Thanks DataInsights  - a huge help, I hadn't thought of unpivoting but it has worked perfectly.