Calculation of the consecutive cumulative by year

[Syndicate_Admin]

Hello:

I have a table with a monthly data for 2024 and 2025. I need to calculate the accumulated value for the total period 2024-2025,

I'm currently calculating it like this:

NOW EAC = TOTALYTD([EAC],'Calendar'[Date])

which generates a graph of this style, but the line of the ACUM EAC is not continuous, but in 2025 it seems that it starts again and does not give the continuity of the data. The EAC line should end by the end of Dec 2025 in total at 12.6 and is finished at 4.9.

These would be the tabulated data...

[nandic]

@Syndicate_Admin just add filter for years like this:

Cumulative Quantity = CALCULATE(SUM(Podaci[Quantity]),ALL('Calendar'),Podaci[Year]>=2024 && Podaci[Date]<=MAX(Podaci[Date]))

or

Cumulative Quantity = CALCULATE(SUM(Podaci[Quantity]),ALL('Calendar'),Podaci[Godina] in {2024,2025} && Podaci[Date]<=MAX(Podaci[Date]))

Cheers,
Nemanja Andic

[Ashish_Mathur]

Hi,

Write this measure

Measure = calculate([EAC],datesbetween(calendar[date],minx(all(calendar]),calendar[date]),max(calendar[date])))

Hope this helps.

[Syndicate_Admin]

I couldn't create the variable...

Measure = CALCULATE([EAC],DATESBETWEEN('Calendar'[Date],MINX(ALL('Calendar','Calendar'[Date]),MAX('Calendar'[Date]))))

I think it's a mistake but I don't know what it is

[Ashish_Mathur]

Hi,

You are missing the closing bracket of the ALL function.  It should be

Measure = CALCULATE([EAC],DATESBETWEEN('Calendar'[Date],MINX(ALL('Calendar'),'Calendar'[Date]),MAX('Calendar'[Date])))

[Syndicate_Admin]

Hello:

With the setting you tell me it works fine, the issue is that I need you to take the information from the year 2024 onwards. The EAC variable has data from previous years that I don't require, so I was making this adjustment to the code but it didn't work =(

Medida_acumulada = CALCULATE([EAC],DATESBETWEEN('Calendar'[Date],DATE(2024,01,01),'Calendar'[Date]),max('Calendar'[Date])))

[Ashish_Mathur]

This one should work

Medida_acumulada = CALCULATE([EAC],DATESBETWEEN('Calendar'[Date],DATE(2024,01,01),max('Calendar'[Date])))

[nandic]

@Syndicate_Admin try using this formula approach:

Cumulative Quantity = CALCULATE(SUM(Table[Quantity]),ALL('Calendar'),Calendar[Date]<=MAX(Calendar[Date]))

No matter how many years you show on chart, it will make cumulative without these year stops.



Cheers,
Nemanja Andic

[Syndicate_Admin]

Hello:

Thanks for the info, this code works but I need to be able to filter the data only for the year 2024 and 2025. The database has information since 2020.

I think that's maybe why totals don't matter