cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

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"))

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.