Cumulative column

[VyshnavTC]

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!

@VyshnavTC 

[Mahesh0016]

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!

[VyshnavTC]

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

[Mahesh0016]

See my result of DAX Its give me correct answer

[Jihwan_Kim]

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]
)