How to match the value of one table using the date to another table with Start Date and End Date

[Anonymous]

I have these two datasets e.g. 

Table 1

Start Date	End Date	Value
01/01/21	07/01/21	1
08/01/21	14/01/21	2
15/01/21	21/01/21	3
22/01/21	28/01/21	4

Table 2

Date

03/01/21

12/01/21

16/01/21

22/01/21

07/01/21

How would I add the Value column from Table 1 to Table 2? I've tried using Filter, Lookupvalue, Calculate, but cannot figure it out

Any suggestion would be much appreciated

[amitchandak · Accepted solution]

@Anonymous ,

new column in table 2

maxx(filter(Table1, Table2[Date] >= Table1[Start date] && Table2[Date] <= Table1[End Date]) , Table1[Value])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8