topic Re: Calculated column in DAX Commands and Tips

Calculated column

Jers19 — Wed, 10 Apr 2024 17:52:57 GMT

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

Re: Calculated column

tamerj1 — Wed, 10 Apr 2024 18:23:30 GMT

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]
)

Re: Calculated column

Jers19 — Thu, 11 Apr 2024 18:50:15 GMT

Hello tamerj1

Thank you so much. It works.