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 extract individual values. But I want to get a cumulative column for one column

 

 

Cumulative Actual Energy = CALCULATE(SUM(Absolute_Master_Table[Actual Energy]),ALL(Absolute_Master_Table),Absolute_Master_Table[Date] <= EARLIER(Absolute_Master_Table[Date]))

 

 

If I did this way it will find sum from the beginning of table, which is not correct. i want it to reset for each appended column so that I can get cumulative energy reading for each projects.

Please help!

Anonymous 

Need Help

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please try the below in order to create expected calcualted column. In my opinion, something like [project name] column has to be included when considering about conditions to add. 

     

     

     

    Cumulative Actual Energy V2 CC =
SUMX (
    FILTER (
        Absolute_Master_Table,
        Absolute_Master_Table[Date] <= EARLIER ( Absolute_Master_Table[Date] )
            && Absolute_Master_Table[ProjectName]
                = EARLIER ( Absolute_Master_Table[ProjectName] )
    ),
    Absolute_Master_Table[Actual Energy]
)

     

     

  • 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.