Forum Discussion
Look for actual value
Hello everybody,
I'm trying to do a search in a table and populate another table.
In the example below I have a table called t1 that has the column Current and Quantity.
What I want is to fill in table 2. That is, look for This month of t2 in t1 and bring the quantity.
If in the table t2 in the Current column there is a repeated value, I have to bring the most current value
jhonatansdias This is a double lookup. Use MAXX(FILTER(...),...) twice essentially. Basically, look up the MAXX date filtering by your month name. Once you have that, do another MAXX(FILTER to filter down to just that date and return that quantity. See if this helps:
2 Replies
Greg_Deckler You helped me a lot. This is exactly what I was looking for.
jhonatansdias This is a double lookup. Use MAXX(FILTER(...),...) twice essentially. Basically, look up the MAXX date filtering by your month name. Once you have that, do another MAXX(FILTER to filter down to just that date and return that quantity. See if this helps:
