Get value filtering another table for the closest date

Hi,

I need a calculated column to get a value with the closest date in another table (Temperature column in items table):

There is no relationship between the tables

I tried this:

Temperature =

var dateitem = Items[Date]

var datetemp=
calculate(MAX(Temperature[Date]),filter(Temperature,Temperature[Date]<=dateitem))

return

calculate(max(Temperature[Temperature]),filter(Temperature,Temperature[Date] = datetemp))

It doesn't work. I get an "insuficient memory" error

Items table has around 25k rows and Temperature table has around 80k rows

Could someone help me?

Thanks,

Thiago