Reading a value from another table between dates ?

[bklyn3]

Hello

I am strugling with the following :

I have a table 1 with following info :

Quantity	Order	FRom Date	To Date
12	124	01/01/22	02/04/22
32	124	02/04/22	4/5/22
45	124	4/5/22	12/2/22

and a second table with a column order and a column date
How do I add a column in the second table with the value "Quantity" based on the column date ? 

Order	Date	Quantity
124	3/3/22	32
124	7/1/22	45

[CNENFRNL · Accepted solution]

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Quantity CC =
MAXX (
    FILTER (
        Table1,
        Table1[Order] = EARLIER ( Table2[Order] )
            && Table1[From Date] <= EARLIER ( Table2[Date] )
            && Table1[To Date] > EARLIER ( Table2[Date] )
    ),
    Table1[Quantity]
)

[CNENFRNL · Accepted solution]