Can you create a running total that starts from 0, based on a date slicer?

[bmay14]

I'm trying to create a running total that will start from 0, based on the filtered date.

For example, if the sales for the years were:

2018: £100

2019: £200

2020: £500

Currently if I set the slicer to 2019, the running total would be:

2019: £300

2020: £800

But I would want it to be:

2019: £200

2020: £700

Thanks in advance!

[amitchandak · Accepted solution]

@bmay14 , Try like

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

or

Cumm Sales =

var _min = minx(allselected('Date'), 'Date'[Date])

return

CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date] <=max(date[Date]) && date[date] >= _min))

[bmay14]

Thank you! The second one worked 🙂