Display most recent record or highest value for each category

amitchandak,

Thanks.

I managed to display the date and marks for the first and last attemps.

First Date = MINX( 
                  FILTER(ALLSELECTED(Table_Marks), Table_Marks[Student]=MIN(Table_Marks[Student])), 
                  Table_Marks[Date] )

First Mark = 
    CALCULATE(
        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 ?

amitchandak 

In your code

Last Status = var _max = maxx(filter(ALLSELECTED(Data), Data[ID] = Max(Data[ID])), Data[Date]) 
return 
CALCULATE(max(Data[Status]), filter((Data) , Data[Date] =_max))

What does this expression do ?

Data[ID] = Max(Data[ID])