Forum Discussion
Solved
Lookup value and date range from a Related Table
Hi, I have a look up table that shows Items, a From and To date along with a price. This table will have the same Item name muliple times with From and To dates ending and starting after each oth...
ToddMate , A new column
New column in table 2 =
maxx(filter(Table1, Table1[Item Name] = table2[Item Name] && Table2[Date Purchase] >= Table1[from] && Table2[Date Purchase] <= Table1[to] ) Table1[Price])
ToddMate , A new column
New column in table 2 =
maxx(filter(Table1, Table1[Item Name] = table2[Item Name] && Table2[Date Purchase] >= Table1[from] && Table2[Date Purchase] <= Table1[to] ) Table1[Price])
Beautiful! Thank you for posting this solution. Will help in several instances with my clients.