Calculate cumulative amount per month over a year

Eftyhia — Thu, 28 Sep 2023 11:54:07 GMT

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?

Re: Calculate cumulative amount per month over a year

lbendlin — Sun, 01 Oct 2023 17:40:59 GMT

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

topic Calculate cumulative amount per month over a year in DAX Commands and Tips

Calculate cumulative amount per month over a year

Re: Calculate cumulative amount per month over a year