Display matrix of pivot table by combining data from two tables

[gudiya999]

Hello,

I am a beginner, can someone help me with this?

I have two tables that look like this

Table 1:

Performance of three people playing Soccer, Archery and tennis

Table 2: Performance Grading Category

Goal - Final display table or matrix 

where actual is the score of the latest date 7/4/2021 and the expected is the max score category reached before the latest match i.e 7/4/2021

Thanks,

Gudiya

[Greg_Deckler · Accepted solution]

@gudiya999 Well, first off, you are going to need to massage your data some. You will want to unpivot those member columns in your first table so that you end up with a Match date column and an Attribute and Value column. Then you are going to need to create a column that classifies each row as one of your categories (Tennis, Archery, etc.) You can do that using split column in Power Query. Then you will likely need a DAX measure or two.