Lookupvalue based on max value

[Anonymous]

Hi Team,

Need your assistance here please. 

I have the complete database of test results in Table 1, the students might have done the test mutiple times at different time stamps (Enddate column shows the date the test was done & Marks column has thier scores). 

In table 2 I have the complete list of students. I want to add 2 columns in Table 2 and want to get the latest date from table 1 Enddate column and the Marks they have scored on that date.  

Thanks in advance.

[amitchandak]

@Anonymous , a new column in table2

End Date = maxx(filter(Table1, Table1[tg_id] = Table2[tgid]), Table1[enddate])

Marks = maxx(filter(Table1, Table1[tg_id] = Table2[tgid] && Table1[enddate] = Table1[End Date]) , Table1[Marks])