Calculated column

[Jers19]

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

[tamerj1 · Accepted solution]

Hi @Jers19 

please try

Price =
MAXX (
FILTER (
Price,
Price[ID] = Sales[ID]
&& Price[Validity Start Date] <= Sales[Date of Sales]
&& Price[Expiry Date] >= Sales[Date of Sales]
),
Price[Price]
)

[Jers19]

Hello @tamerj1 

Thank you so much.  It works.