Forum Discussion

ksfx77's avatar
ksfx77
Icon for Helper I rankHelper I
5 years ago
Solved

How to select the most recent value from another table based on matching id's

Hi Guys,   Happy Monday!   I feel like this should be simple, but getting the most recent value in context has been tripping me up, and any guidance will be appreciated.   I have a bunch of ses...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    ksfx77 , you have to try a column like

     

    new column =
    var _max = maxx(filter(Table1, Table1[ID] = Table2[ID]), Table1[Date])
    return
    maxx(filter(Table1, Table1[ID] = Table2[ID] && Table1[Date] =_max), Table1[Value])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

ksfx77 , you have to try a column like

 

new column =
var _max = maxx(filter(Table1, Table1[ID] = Table2[ID]), Table1[Date])
return
maxx(filter(Table1, Table1[ID] = Table2[ID] && Table1[Date] =_max), Table1[Value])

  • ksfx77's avatar
    ksfx77
    Icon for Helper I rankHelper I
    5 years ago

    Thanks that indeed worked a charm!

     

    Out of interest, if I wanted to chose the value based on a rank of the value itself, instead of the most recent date, is that a simple change?