Get the earlier matching result

[setis]

Dear all,

I have one table with rates:

Date	Rate
01-01-2020	0,5
02-01-2020	0,4
04-01-2020	0,6
05-01-2020	0,3

I need a calculate column in another table bringing these rates. If there is no matching date, I need the earlier date to the missing one. 

This is the expected results when the 03-01-2020 is missing in the above table:

Date	Exchange
01-01-2020	0,5
02-01-2020	0,4
03-01-2020	0,4
04-01-2020	0,6

It doesn't find any match for the 03-01-2020 and finds the first available before that, the rate for the 02-01-2020 that is 0,4.

I'm not sure how to approach this. 

I tried this but the results are not correct:

Thank you in advance

[amitchandak · Accepted solution]

@setis , Instead of first nonblank try .

lastnonblankvalue([Date],[Rate])

rest of the Column formula will be the same.

The assumption, You have the missing date in the table and creating a new column.