cancel
Showing results for
Did you mean:
Helper IV

## 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
MVP

## Re: Cumulative sum for a line chart

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

Resident Rockstar

## 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.
3 REPLIES 3
MVP

## Re: Cumulative sum for a line chart

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

Resident Rockstar

## 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.
Regular Visitor

## Re: Cumulative sum for a line chart

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.

Announcements

#### ‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors