Forum Discussion

Post Prodigy

10 years ago

Solved

Cumulative Total

Hi, I'm at an absolute loss as to how to calculate a cumulative total. I've tried googling, reading the forums, following the documentation, decomposing the calculation, trying it as both a measu...

Need Help

Show and Tell

Sean

10 years ago

ElliotP Sorry about the original post. It was from my phone and had typos :smileywink:

Okay here is the formula for Running Total as a Calculated Column (prorerly formatted)

Running Total COLUMN =
CALCULATE (
    SUM ( 'All Web Site Data (2)'[UniquePageviews] ),
    ALL ( 'All Web Site Data (2)' ),
    'All Web Site Data (2)'[Date] <= EARLIER ( 'All Web Site Data (2)'[Date] )
)

And as you can see it works! :smileyhappy:

And here's the MEASURE formula

Running Total MEASURE = 
CALCULATE (
    SUM ( 'All Web Site Data (2)'[UniquePageviews] ),
    FILTER (
        ALL ( 'All Web Site Data (2)' ),
        'All Web Site Data (2)'[Date] <= MAX ( 'All Web Site Data (2)'[Date] )
    )
)

Which also works...

Sean

Community Champion

10 years ago

ElliotP Sorry about the original post. It was from my phone and had typos :smileywink:

Okay here is the formula for Running Total as a Calculated Column (prorerly formatted)

Running Total COLUMN =
CALCULATE (
    SUM ( 'All Web Site Data (2)'[UniquePageviews] ),
    ALL ( 'All Web Site Data (2)' ),
    'All Web Site Data (2)'[Date] <= EARLIER ( 'All Web Site Data (2)'[Date] )
)

And as you can see it works! :smileyhappy:

And here's the MEASURE formula

Running Total MEASURE = 
CALCULATE (
    SUM ( 'All Web Site Data (2)'[UniquePageviews] ),
    FILTER (
        ALL ( 'All Web Site Data (2)' ),
        'All Web Site Data (2)'[Date] <= MAX ( 'All Web Site Data (2)'[Date] )
    )
)

Which also works...