DAX formula to get latest score for a given month for a student

[priyankaj1311]

I need a dax formula to get the latest score for each student for a given month

Table structure: Student Name, Date, Score, Session

In a given month, there are multiple scores (one for each session). I just need to get the score for the latest date for any student in that month. It does not matter which session it is. Then I need to show the avg. of this latest score in a graph plotted for each month.

Here is what I tried so far but I don't how to do it with dates instead of session

```

Latest score =
var curr = LASTNONBLANK(tbl[student_name],[student_name])
return
LOOKUPVALUE(tbl[score],tbl[session],MAXX(FILTER(ALL(tbl),tbl[student_name]=curr),[session]),tbl[student_name],curr)

```

[Greg_Deckler]

@priyankaj1311 So generally this is a double lookup essentially. Use something like this: Lookup Min/Max - Microsoft Fabric Community