Forum Discussion
Running Total Chart over Multiple Years
Hello all, Question regarding both DAX and getteing the correct chart. Problem: I want to plot multiple cumulative YTD sales plots on one plot/tile. I have succesfully been able to do that ...
I tried creating an example of what you need. Can you refer to page and let me know what exactly you are looking for. I created two measures and added them to two graphs. https://www.dropbox.com/s/tu56wooipvoyoy3/CompareRange_timedim_YearTillDate.pbix?dl=0
Sure. amitchandak
The code I am using to calculate the running total sales are the following:
Measure = CALCULATE( SUM(SalesPerDate[Initiates]), FILTER (ALLSELECTED(SalesPerDate), SalesPerDate[Date] <= MAX(SalesPerDate[Date])))
This is giving me the desired outcome of calculating the annual fiscal year todate running total per date with date on the x axis and sales on the y axis. However, I want to add multiple years - not only the year that I select on the filter/slicer.
Ideally it would look like this....except for tornados it would be sales. Each line would be a different year. Does this make sense?
amitchandak
Super User
Super UserI tried creating an example of what you need. Can you refer to page and let me know what exactly you are looking for. I created two measures and added them to two graphs. https://www.dropbox.com/s/tu56wooipvoyoy3/CompareRange_timedim_YearTillDate.pbix?dl=0