Help with sum between two dates

DAX DAX Calculations
2

Hi @cwnoll,

Welcome to the forum!

There are many different ways to approach this. You’re looking for a cumulative pattern on a monthly granularity with an offset to the current month over a fixed period.

The Date table in the sample includes a MonthOffset, you can find a link to that here

Cum Sales prev 6-12 months = 
VAR ThisMonth = SELECTEDVALUE( Dates[MonthOffset], LOOKUPVALUE( Dates[MonthOffset], Dates[Date], TODAY()))
RETURN

CALCULATE( [Total Sales],
    FILTER( ALL( Dates ),
        Dates[MonthOffset] >= ThisMonth -11 &&
        Dates[MonthOffset] <= ThisMonth -6
    )
)

image
image730×310 8.55 KB

Here’s my sample file. I hope this is helpful.
Cumulative value.pbix (138.4 KB)

3 Likes