Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
priyankaj1311
New Member

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

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)

```

1 REPLY 1
Greg_Deckler
Super User
Super User

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

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.