Forum Discussion
calculate cumulative value with selected date range
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
Anonymous , try a measure like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
1 Reply
- amitchandak
Super User
Anonymous , try a measure like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))