cancel
Showing results for
Did you mean: Frequent Visitor

## Monthly Values with YTD Running Total for Multiple Years

Hello,

This one is proving to be quite difficult! I am trying to show monthly weights for a three-year period, and would like a YTD running total line for each of the years on a secondary axis. I know I can do these as separate measures, but then the colors of the column and line will not match up, making it very confusing to look at.

Is there any way to accomplish this??

Below is the DAX I'm using for the Weight YTD line in the image, which is cumulating just the 2022 sales by month. The ideal outcome would be three separate YTD lines that color correspond to the same year in the column values.

Weight YTD =
CALCULATE(
[Total Weight],
DATESYTD('Dates Table'[Date],"31/12")
) Thanks for looking.

1 ACCEPTED SOLUTION  Super User

@ksoukup , In standard combo viusal,  line will not use legned

You may need additional measures like

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

2nd Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))  Super User

@ksoukup , In standard combo viusal,  line will not use legned

You may need additional measures like

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

2nd Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))  