Hello,

I need a help with DAX equivalent measure of SUMIF function where delivery date <= Expected Date

sumif( qty, del date <= exp date)

Table 1
Key Exp Date
1A1 06/11/2021

Table 2
Key Trans Date Qty
1A1 05/11/2021 4
1A1 03/11/2021 5


Result = 9

Thanks,
Piku