Forum Discussion
Solved
Lookup date from one table within date range in another table
Dear colleagues, I have a table with list of names and their vaccination date. Next table contains the names and when they were hospitalized from – to. Vaccination table Hospital table ...
As variant
=LET( d, FILTER( T_Vacc[vaccination date], T_Vacc[Name] = [@Name] ), check, (MAX(d) >= [@[Hospitalized from]]) * (MIN(d) <= [@[Hospitalized to]]), IF(check, "Yes", "No") )
As variant
=LET(
d, FILTER(
T_Vacc[vaccination date],
T_Vacc[Name] = [@Name]
),
check,
(MAX(d) >= [@[Hospitalized from]]) *
(MIN(d) <= [@[Hospitalized to]]),
IF(check, "Yes", "No")
)
@ Sergei Baklan, thank You for a modern solution. This is the way, how to learn new functions ...