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 colu...
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])