Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Kristofferaabo
Helper IV
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

cumulative_calc.jpg

 

 

2 ACCEPTED SOLUTIONS

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

View solution in original post

v-piga-msft
Resident Rockstar
Resident Rockstar

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.

View solution in original post

6 REPLIES 6
v-piga-msft
Resident Rockstar
Resident Rockstar

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

@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.

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

Really neat solution, thanks! 😎

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

Anonymous
Not applicable

Thanks for the quick solution 🙂

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.