Forum Discussion
Cumulative Total
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...
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...
Hi sir running total measure is workong in my case but it does not show differnt value for differnet categories .
I want to show a cumulated covid cases as per district but I cant do it I tried many formula sice two day
someone help me
thanks in advance !
WHEN I USE MEASURE
| date | district | results | no of confirmed | ||||||
| 20-5-20 | A | POS | 1 | ||||||
| 21-5 | A | NEG | 0 | ||||||
| 22-5 | A | POS | 1 | ||||||
| 23-5 | A | NEG | 0 | ||||||
| 24-5 | B | POS | 1 | ||||||
| 25-5 | B | POS | 1 | ||||||
| 26-5 | B | POS | 1 | ||||||
| 27-5 | C | POS | 1 |