cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
MVP

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

Resident Rockstar

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.
6 REPLIES 6
Resident Rockstar

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.
Anonymous
Not applicable

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.

MVP

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

Really neat solution, thanks! 😎

Frequent Visitor

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

Anonymous
Not applicable

Thanks for the quick solution 🙂

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors