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

slittleson — Sat, 18 Dec 2021 18:13:20 GMT

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....!!

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

ValtteriN — Sat, 18 Dec 2021 21:55:22 GMT

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!

topic Re: Variable date line chart that ALWAYS starts at 0...? in DAX Commands and Tips

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

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