DAX grouping. Filter Values in a group based on the MAX Value in the other column of a group

[YGL18]

I have ‘StudentAssessment’ table:

StudentID    Title             Subject       Date                 Result

  1             | Geometry     | Math   |   2017-05-05    |     425

  1             | Geometry     | Math   |    2016-05-05   |     438

  2             | Geometry     | Math   |   2017-05-05    |     388

  2             | Geometry     | Math   |   2017-12-12    |     416

I need to filter it so each student has one Result where the Date is MAX:

StudentID    Title            Subject       Date                  Result

  1             |  Geometry   | Math      |  2017-05-05     |    425

  2             |  Geometry   | Math      | 2017-12-12      |   416

It has to be a filtered table in a variable. "Result" is a "string"

[Zubair_Muhammad · Accepted solution]

@YGL18

One way is to have calculated table

From Modelling Tab >> New Table

Calculated Table =
GENERATE (
    SELECTCOLUMNS ( VALUES ( Table1[StudentID] ), "ID", [StudentID] ),
    CALCULATETABLE ( TOPN ( 1, Table1, [Date], DESC ) )
)