Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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!!
You are a live saver!
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!!