Forum Discussion
vyacheslavg
Helper II
Helper IIHow to lookup value from another table in date range, using date?
Hello, Could you please help, cannot figure out a seeminlgy simple task. The task is very easy for human to grasp. In a simplest case, we have 2 tables with dates and statuses. Table...
Hi,
Try these calculated column formulas in the Products Table
date_component=CALCULATE(MAX(Components[date_component]),FILTER(Components,Components[component_id]=EARLIER([component_id])&&Components[date_component]<=EARLIER([date_product])))
Status=LOOKUPVALUE(Components[Status],[component_id],[component_id],Components[date_component],[date_component])
Hope this helps.
Thanks Ashish Mathur - had a similar issue and this solved the problem perfectly.
Ashish_Mathur
Super User
Super UserYou are welcome.