Create a rolling measure which rebases graphically using the date filters

[jcozens]

Hi, 

I'm trying to build a line graph which tracks the accumulated growth of sales over any date period selected by the date filters. 

I've managed to get the running total measure that allows a daily growth figure which I can plot onto a line graph. However when I change the date range on the filter, the values on the graph (understandably) do not start at 0 but at the accumulated number at that date. 

How do I get the running total measure to start calculating from the date selected in the page filters? 

[v-eachen-msft · Accepted solution]

Hi @jcozens ,

You could create a measure to get the dynamic result.

Here is my test file for your reference.