Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Helper IV
8 years ago
Solved

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 ...
Show and Tell
Tips and Tricks
  • deldersveld's avatar
    deldersveld
    8 years ago

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

  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    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.

     

     

    Best Regards,

    Cherry

deldersveld's avatar
deldersveld
Resident Rockstar
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the quick solution 🙂

  • juliarwk's avatar
    juliarwk
    Frequent Visitor
    3 years ago

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

  • kymramosrpo's avatar
    kymramosrpo
    Advocate V
    3 years ago

    Really neat solution, thanks! 😎