LOOKUPVALUE Nearest not exact

1.12 would return 0 ???

is this correct? or it should be 1

EDIT: solved - it's actually working - I had typed an incorrect year and was looking at a wrong date.

I'm trying to get this working for my case.

I have two tables:

1. Table 1 - Products: product name, dates, price on date, etc.
2. Table 2 - Exchange rates: unique dates, currencies, exchange rate

I'm trying to create a measure that, for each row of the Table 1 Products:

• Gets the date
• Finds the currency of that product (done)
• Finds the nearest date in Table 2 Exchange Rates
• Gets the exchange rate for that currency on the selected (closest) date

I've done a few attempts but so far what I get is:

- A date that is not the closest one

- No exchange rate for the [incorrectly] found closest date (even if it exists)

The measure is only working if there is an exact same date on Table 2 Exchange rates (which is impractical).

Below are my tables (sample):

Table 1 Products

Table 2 Exchange Rates

My latest attempt in the measure:

=maxx(
   TOPN (
        1,
        'Table2_Exchange_Rates',
        ABS(
           CALCULATE(
                     sum('Table1_Products'[Date]) - 
                     sum('Table2_Exchange_Rates'[Date]) 
                    )
         ),ASC
    ),
   'Table2_Exchange_Rates'[Date]
)

Thanks