Forum Discussion
Lookupvalue based on max value
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.
1 Reply
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])
