Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cumulative column

If I have appended rows which, how do I get cumulative column but starting from new in each appended column? The way I made this master table is by appending different projects and I use slicer to e...
Need Help
Mahesh0016's avatar
Mahesh0016
Super User
3 years ago
Cumulative Actual Energy = CALCULATE(SUM(Absolute_Master_Table[Actual Energy]),ALL(Absolute_Master_Table),Absolute_Master_Table[Date] <= MAX(Absolute_Master_Table[Date]))

Try this formula if it is helpful for you kindly accept as a solution mark.
thank you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Sorry, this doesn't work. It gives total sum and stores the same value in all rows.

    • Mahesh0016's avatar
      Mahesh0016
      Super User
      3 years ago

      See my result of DAX Its give me correct answer