Cumulative total

[Anonymous]

Hi, 

I need help to write my cumulative total measure. 

I have the column [Beloeb] for my financial items i want to sum from the start date 12-31-2015 and to a given month. The start date must in every situatio be 12-31-2015. The end date should in every situation be the last day of a given month. So if I want to see the total amount for April 2021 the period will be from 12-31-2015 to 04-30-2021. 

I have so far tried this, but it does not work:

Total_beloeb =

CALCULATE(

SUM('dm fct_Finansposter'[Beloeb]),

ALL('dm fct_Finansposter'[Beloeb]),

EOMONTH(DATE(2015,12,31),12) <= MAX(DATE(2021,12,31))

)

I hope someone can help me, as i really need help to write this function. 🙂

Best regards

Line

[tex628 · Accepted solution]

Hi! 

Add a calendar table with a relationship between your finansposter date column and the calendar table date column. Then try the following measure:

Total_beloeb =
VAR Mdate = MAX('Calendar'[Date])
Return
CALCULATE(
SUM('dm fct_Finansposter'[Beloeb]),
ALL('Calendar'),
'Calendar'[Date]>=DATE(2015,12,31),
'Calendar'[Date]<=mDate
)

[Anonymous]

Thank you for your help, it worked!