topic Re: Reading a value from another table between dates ? in DAX Commands and Tips

Reading a value from another table between dates ?

bklyn3 — Fri, 02 Dec 2022 20:25:56 GMT

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

Re: Reading a value from another table between dates ?

CNENFRNL — Sat, 03 Dec 2022 08:28:10 GMT

Re: Reading a value from another table between dates ?

Jihwan_Kim — Sat, 03 Dec 2022 08:30:54 GMT

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] )