An alternative way to sum values for a specified date range?

[alvinlinjr]

Hello community! I created this measure to sum total savings between two dates, [Monthly Updated Transition Date] & [End Transition Date], using an IF statement:

JUL Savings = 
IF(DATE(2022, 7, 1) >= MIN('Project Data'[Monthly Updated Transition Date]) && DATE(2022, 7, 1) < MIN('Project Data'[End Transition Date]),    
        SUMX(VALUES('Project Data'[Concatenate]),
            CALCULATE(SUM('Query_Sums'[JUL ]) * SUM('Project Data'[Savings per SKU (per actual case)]))
        ),
    BLANK()
 )

While this evaluates a result for each Project Name, it does not evaluate a Total in the matrix visual:

 Are there other ways to re-write the DAX, such as by using ISONORAFTER? Thanks so much for your help in advance!

[alvinlinjr]

Works perfectly - thanks so much, @tamerj1 !

[tamerj1 · Accepted solution]

Hi @alvinlinjr 

Please try

JUL Savings =
SUMX (
VALUES ( 'Project Data'[Concatenate] ),
CALCULATE (
IF (
DATE ( 2022, 7, 1 ) >= MIN ( 'Project Data'[Monthly Updated Transition Date] )
&& DATE ( 2022, 7, 1 ) < MIN ( 'Project Data'[End Transition Date] ),
SUM ( 'Query_Sums'[JUL ] )
* SUM ( 'Project Data'[Savings per SKU (per actual case)] ),
BLANK ()
)
)
)