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])))
amitchandak
Super User
Super UserAnonymous , try a measure like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))