Calculated column

Hello,

I have two tables (without relation)

• table of sales with two columns
  • ID
  • date of sales
• table of prices with four columns
  • ID
  • validity start date
  • expiry date
  • price

I'd like to add a calculated column in the "sales" table with the price that was valid.

I try with "filter" but I have a result only when the sales date is egal to the validity start date 😞

Thank you for your help