Cumulative total

[prashantg364]

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.

[tamerj1]

Hi @prashantg364 
Please try

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

[Greg_Deckler]

@prashantg364 Try this: Better Running Total - Microsoft Power BI Community

[prashantg364]

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