Forum Discussion

bklyn3's avatar
bklyn3
Advocate II
3 years ago
Solved

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/...
beginner
columns
DAX
DAX Calculation
DAX Command
Find multiple values
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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]
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

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