Forum Discussion
jay_patel
Helper IV
Helper IVHow 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 | 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
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])
1 Reply
- amitchandak
Super User
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])