I managed to display the date and marks for the first and last attemps.
First Date = MINX(
First Mark =
max(Table_Marks[Marks]), FILTER(Table_Marks, Table_Marks[Date]= [First Date]))
However I am unable to get the date for the highest marks.
I have these 2 measures :
Highest Mark = max(Table_Marks[Marks])
Highest Marks Date = CALCULATE(max(Table_Marks[Date]), FILTER(Table_Marks, Table_Marks[Marks]= [Highest Mark]))
This will give an incorrect date when a lower mark is attained later
In addition, how do I calculate the Average of all the last attempt marks ?