Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.