Get value filtering another table for the closest date

[ThiagoDuarte]

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

[Kannan_n]

Hi @ThiagoDuarte

Use the performance analyzer to check which data taking more space. 

If the data can sharable please share with me I will check and let you know. 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer