Forum Discussion
Solved
Running total and reference line
I am trying to build a running total for CY and PY for the month like the graph below. I would also like budget and forecast to be reference lines on the top.
solved it with your help and added a filter for current year. Then the following measures
Full year budget (one number) =CALCULATE([Total Budget],DATESINPERIOD(DimDate[Date],DATE(2024,1,01),1,YEAR))Running YTD last year =CALCULATE([Running YTD],SAMEPERIODLASTYEAR(DimDate[Date]))Running YTD =CALCULATE([Total sales],DATESYTD(DimDate[Date]))
Create measures for: CY Running Total, PY Running Total, Budget, Forecast.
Select a Line Chart and add your Date field to the Axis.
Add CY Running Total and PY Running Total to the Values.
In the Analytics pane, add Constant Lines for both Budget and Forecast.
If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
I have a measure for YTD running total in general
Running YTD Sales = IF([ShowValueForSales]=TRUE(),TOTALYTD([Total sales],DimDate[Date]))
This one gives me the graph below but I cant use that one when i want to see all three year Jan-Dec
Then i am not sure how to make the budget one reference line on the top