Forum Discussion

Sander1401's avatar
Sander1401
Icon for Helper II rankHelper II
2 years ago
Solved

RunningSum in DAX, multiple bookingyears

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 bookingy...
Need Help
  • Kishore_KVN's avatar
    Kishore_KVN
    2 years ago

    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!!

Sander1401's avatar
Sander1401
Icon for Helper II rankHelper II
2 years ago

You are a live saver!