Calculate cumulative amount per month over a year

[Eftyhia]

Hello all,

I would like to create a calculated measure in power bi that will calculate cumulative 'Del HL'.

Month	Del HL	Cumulative Del HL
1	15000	15000
2	2000	17000
3	4000	21000

The code that I am using is the below but it gives back in Cumulative Del HL column the very same values as in Del HL column without cumulative calculation:

Del HL running total in Date =

CALCULATE(

    SUM('Volume sales 2023'[Del HL]),

    FILTER(

        ALLSELECTED('Holidays'[Date]),

        ISONORAFTER('Holidays'[Date], MAX('Holidays'[Date]), DESC)

    )

)

 Also tables that I am using are the below:

Could you please assist?

[lbendlin · Accepted solution]

'Holidays' is not marked as a Date table.  It is recommended that all tables used for time intelligence functions are marked as data tables.