cancel
Showing results for
Did you mean:
Highlighted
Member

## Cumulative sum for a line chart

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

2 ACCEPTED SOLUTIONS

Accepted Solutions

## Re: Cumulative sum for a line chart

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

Community Support Team

## Re: Cumulative sum for a line chart

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2

## Re: Cumulative sum for a line chart

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

Community Support Team

## Re: Cumulative sum for a line chart

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.