Variable date line chart that ALWAYS starts at 0...?

[slittleson]

I work in healthcare and need to produce a VLAD chart that looks at outcomes over time.  It is a fairly sime rolling calculation, but Im stuck on the fact it needs a variable  date filter, and the first point always has to be 0 (so whatever the start date, the y axis is zero'd, and  the rolling sum starts).  Just cant get the filtered 0....!!

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:

RT with selected time period =

var _sdate = min('Calendar example'[Date])

var _edate = MAX('Calendar example'[Date]) //Mark end and start date based on slicer selection

var allRT = CALCULATE(SUM('Quarter calculations'[Value]),

'Calendar example'[Date]<=_edate,ALL('Calendar example')) //calculate running total until the end date

var beforeRT = CALCULATE(SUM('Quarter calculations'[Value]),'Calendar example'[Date]<=_sdate,

ALL('Calendar example')) return //calculate RT until start date

allRT-beforeRT //Do substraction to get the RT between slicer dates

End result:

I hope this helps to solve your issue and if it does consider accepting this post as a solution and giving the post a thumbs up!