calculate cumulative value with selected date range

[Anonymous]

Hi guys, I want to calculate a cumulative value with selected date range, and the slicer may switch  M to W(week) or D(day),

As I am new to use DAX, do you have any ideas to fullfill that? Thank you

[amitchandak · Accepted solution]

@Anonymous , try a measure like

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))