Forum Discussion
Solved
How to Gst Values having Maximum Date in Lookup function to get from Table 2 in Table 1
Hi All, I have 2 Table , Table 1 & Table 2 Table 1 ID A B C Table 2 ID values Date A 2 24-Sep A 1 02-Oct B 55 01-Aug B...
jay_patel , Try a new column in table1
var _max = maxx(filter(Table2, Table1[ID] = Table2[ID]), Table2[Date])
return
maxx(filter(Table2, Table1[ID] = Table2[ID] && Table2[Date] =_max), COst[values])
jay_patel , Try a new column in table1
var _max = maxx(filter(Table2, Table1[ID] = Table2[ID]), Table2[Date])
return
maxx(filter(Table2, Table1[ID] = Table2[ID] && Table2[Date] =_max), COst[values])