How to Gst Values having Maximum Date in Lookup function to get from Table 2 in Table 1

[jay_patel]

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	64	03-Oct

Want Values in Table 1 , by matching Id but for Maximum date.
So, For ID= A, the value should be 1 

and for ID = B, the value should be 64

@amitchandak 

Thanks in Advance

[amitchandak · Accepted solution]

@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])