How can I: Returns the most recent value, filtering two dates.

[henriquerzatk]

Hi everyone.

I have the following situation:

I have two tables, and I need to create a column in table 2 (ID_2), which brings me ID_2 of type "Mtk", that its date_ID2 is the most recent, but less than the date_ID_3, from table 1; 

Thanks all. 

[amitchandak · Accepted solution]

@henriquerzatk , New column in table2

Maxx(filter(Table1, Table1[ID_1] = Table2[ID_1] && Table1[Date_ID2] <= Table2[Date_ID3]), Table1[ID_2])

[henriquerzatk]

Wow, thank you so much, this helped me a lot. 🙌

Now a second doubt, continuing in the same situation.

Is it possible, I determine a number of days, as a limit for it to pull or not the value of ID_2?

Example:

Only bring ID_2 if: Date_ID3 - Date_ID2 <= 120

Thanks.