Forum Discussion

paulfink's avatar
paulfink
Post Patron
5 years ago

Cumulative Sum

Hi guys,   I need a new Cumulative Sum formula.   The current one i have works fine but now as i am adding more stuff into my table it breaks the measure. Cumulative Sum = CALCULATE(SUM('Table1...
Need Help
paulfink's avatar
paulfink
Post Patron
5 years ago

Hello Anonymous, the Index is not the issue here. Its primary purpose is to seperate lines from the table.

 

As there can be more than 1 date in multiple lines, using the date would could the figures to group up instead of Cumulate. Such as:

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi paulfink,

So you mean you want to aggregate the values based on their date values instead of rolling the index? If this is a case, you can try the following measure formula:

Measure =
VAR currDate =
    MAX ( Table[Date] )
RETURN
    CALCULATE (
        SUM ( Table[Value] ),
        FILTER ( ALLSELECTED ( Table ), Table[Date] <= currDate )
    )

Regards,

Xiaoxin Sheng