cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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

cumulative_calc.jpg

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
deldersveld
Advisor

Re: Cumulative sum for a line chart

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

Community Support Team
Community Support Team

Re: Cumulative sum for a line chart

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.

 

11Capture.PNG

 

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
deldersveld
Advisor

Re: Cumulative sum for a line chart

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

Community Support Team
Community Support Team

Re: Cumulative sum for a line chart

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.

 

11Capture.PNG

 

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.