Cumulative sum for a line chart

[Kristofferaabo]

Hi,

I have a set of data with a a column of meeting dates each for a 'sale', I would like to make a chart visualizing this sale growing over time. (cumulative sum??)

Y axis total sale (count of the sale=, X axis meeting date

Please find a screenshot of my dataset

Thanks

Kristoffer

[deldersveld · Accepted solution]

Try the "Running Total" Quick Measure and total it over date.

[v-piga-msft · Accepted solution]

Hi @Kristofferaabo,

You could create the measure below to get the cumulative sum of the sales.

total =
CALCULATE (
    SUM ( table5[count of sales] ),
    FILTER (
        ALL ( table5 ),
        'table5'[Meeting date] <= MAX ( 'table5'[Meeting date] )
    )
)

 Then you will get your excepted line chart.

Best Regards,

Cherry

[Anonymous]

@v-piga-msft 

Would it be possible to add a grouping condition to that. Say I have a column category, then I would like the cummulative sum to be at a category level.

[deldersveld · Accepted solution]

Try the "Running Total" Quick Measure and total it over date.

[kymramosrpo]

Really neat solution, thanks! 😎

[juliarwk]

Thanks a lot!! This was an easy solution that saved me a lot of time.

[Anonymous]

Thanks for the quick solution 🙂