Compare average score with two or more result

[Anonymous]

Hi friend,

I'm new to Power Bi and I'm looking for solution to getting a result of comparison of average score by subjects for student. Some student completed one exam, and some completed more. In my case, the max number of exam is 3. So, when I get average score of exam #3 I want to compare the average result of previous exams for the same students who has exam #3 only.

Below is the data table. appreciate for your helps. Thanks,
This is my data.

https://drive.google.com/file/d/14GyaMQ_A2ITlitOx0G2AobnYlzSw9V1g/view?usp=sharing 

[daxer-almighty]

No answers because the question is about as clear as mud. I'd recommend reading this first:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490