Need help with doing a Cummulative to a Moving Measure

[Anonymous]

Hi - is there a way to create a Cummulative dax measure for the following already calculated Moving 8 weeks Sales Measure : 

Moving 8wk Sales =

CALCULATE(sum(SalesLines[Quantity]),DATESINPERIOD(Dates[Date],MAX(Dates[Date]),-56,DAY))

The result I wanted to achieve is in the  column D below : 

[Mahesh0016]

@Anonymous I hope this helps you! THANK YOU!!

Cummulative 8wk Sales =

CALCULATE([Moving 8wk Sales],Dates[Month]<=MAX(Dates[Month])

[Anonymous]

Hello there - thanks for the reply. Unfortunately it gives the same results as my original "Moving 8 wks" calculation : 

Cummulative 8wk Sales =

CALCULATE([Moving 8wk Sales],Dates[Date]<=MAX(Dates[Date]))

Moving 8wk Sales =

CALCULATE(sum(SalesLines[Quantity]),DATESINPERIOD(Dates[Date],MAX(Dates[Date]),-56,DAY))

[Mahesh0016]

Hii @Anonymous you have used Date[date] column in filter but look in my measure i have used Date[Month] column , Please Try that and share your views.THANK YOU!!

[Anonymous]

Hello again - I used Date[Month] - but it looks the same : 

The Date[Month] column I have is as per below : 

[Mahesh0016]

@Anonymous I hope this helps you!THANK YOU!!

Cummlative_sum =

CALCULATE ( [TotalSales], FILTER(ALLSELECTED('Date'),'Date'[Month] <= MAX ( 'Date'[Month] ) )

)

[Anonymous]

Hi again,

Thanks again for the help - but this time it has no result.  It looks like a Cummulative may not be possible to add onto a Measure that has a "DatesIn Period" in there..

Moving 8wk Sales =

CALCULATE(sum(SalesLines[Quantity]),DATESINPERIOD(Dates[Date],MAX(Dates[Date]),-56,DAY))

Cummulative 8wk Sales2 =

CALCULATE([Moving 8wk Sales],FILTER(ALLSELECTED(Dates),Dates[Month]<=MAX(Dates[Month])))