Forum Discussion

Thigs's avatar
Thigs
Helper IV
4 years ago
Solved

Calculated Column Running Total

Hi all,  I've looked at several other posts answering similar questions but can't find exactly what I need. Basically, I have a column for Index (starting at 1), and a column for quantity of items. ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Thigs 

    for a calculated column you can use 

    Cumulative Total =
SUMX (
    FILTER ( 'Data', 'Data'[Index] <= EARLIER ( 'Data'[Index] ) ),
    'Data'[QtyPicked]
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Thigs 

for a calculated column you can use 

Cumulative Total =
SUMX (
    FILTER ( 'Data', 'Data'[Index] <= EARLIER ( 'Data'[Index] ) ),
    'Data'[QtyPicked]
)