Finding currency rate by date


We have two different datasets: one with rates by date and currency and an other with different transactions. I want to merge the correct rate for each transaction by currency and date but if there is no rate at for a certain date we should use the last avalilable before the given date for that currency.
What is the best practice approach for these kind of issues?

Thanks in advance,

You can use the “Fill down” action to fill down empty cells that don’t have a conversion rate. Sort the table in the reverse order if you need to “fill up”.

Thank you, we managed it with a database trigger instead. Performancewise it’s better.