RunningSum in DAX, multiple bookingyears

[Sander1401]

Hi All,

I am struggling wioth RunningSum in DAX.
I want to conmstruct a linegraph with the RunningSum/RunningTotal for arrivalyear 2024.
As you can see in the excelfile I have multiple bookingyears for arrivalyear 2024, so it looks like I cannot use TOTALYTD.
Can anyone help me construct a formula which can help me out on this?
Please see the excelfile here:
RunningSum.xlsx

Thanks all!

[Sander1401]

You are a live saver!

[Kishore_KVN · Accepted solution]

Hello @Sander1401 ,
Create running total measure as follows:

Running Total = 
CALCULATE(SUM('Table'[Sale]),
ALLSELECTED('Table'),
'Table'[Date booking] <=MAX('Table'[Date booking]))

Please refer attachment for details. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!