Lookup + first date filter

Hi team.   I have two tables like the next: Table Transfer ID Transfer Date 1 03/20/2001 1 10/21/2022 2 01/01/2022 2 11/10/2005 3 03/09/2020   Table Master ID Fi...