topic Re: Cumulative total in DAX Commands and Tips

Cumulative total

prashantg364 — Thu, 16 Mar 2023 10:22:00 GMT

I have data set as shown below

I created a measure for the cumulative total with the below formula

CumulativeSale =

CALCULATE (

SUM ( 'Table'[Product sale] ),

FILTER (

ALL ( 'Table'[Date] ),

'Table'[Date] <= MAX('Table'[Date] )

)

When I try the visualization by keeping the date on the x-axis, I get the correct output

But when I try to change the x-axis to month or week... output generated is incorrect.

Pls help and suggest how I can get the cumulative total for multiple different x-axis in a single visualization.

Greg_Deckler — Thu, 16 Mar 2023 10:32:32 GMT

tamerj1 — Thu, 16 Mar 2023 11:30:22 GMT

Hi prashantg364
Please try

CumulativeSale = CALCULATE ( SUM ( 'Table'[Product sale] ), 'Table'[Date] <= MAX ( 'Table'[Date] ), ALL ( 'Table' ) )

prashantg364 — Fri, 17 Mar 2023 03:51:51 GMT

Thanks for the solution... it works for my dataset.