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