Jers19New Member2 years agoSolvedCalculated 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...Show Moretamerj12 years agoHi 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])
tamerj12 years agoHi 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])
tamerj12 years agoHi 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])
tamerj1Community Champion2 years agoHi 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])
Related contentTMDL - calculated columnDirect Lake Model - Calculated Column/TablesPower Query or Calculated columnsIF calculated columnDynamic Variable in Calculated Columns
