topic Re: An alternative way to sum values for a specified date range? in DAX Commands and Tips

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

alvinlinjr — Fri, 13 Jan 2023 15:27:08 GMT

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!

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

tamerj1 — Fri, 13 Jan 2023 15:46:07 GMT

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

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

alvinlinjr — Fri, 13 Jan 2023 15:58:00 GMT

Works perfectly - thanks so much, tamerj1 !