cancel
Showing results for
Did you mean:
Frequent Visitor

## Reading a value from another table between dates ?

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

2 ACCEPTED SOLUTIONS
Super User

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!
Super User

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

2 REPLIES 2
Super User

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Super User

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!