Forum Discussion

shaebert's avatar
shaebert
Helper III
3 years ago
Solved

Line Chart Comparing Running Total

Hello, below is an example of data I have for a table for people who register for events from two different years. I am looking to create a line graph that compares cumulative/running total over time...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    shaebert , You can get cumulative measure with help from date table 

     

    example

    Cumm = CALCULATE(SUM(Table[Value]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

     

    or

     

    Cumm = CALCULATE(SUM(Table[Value]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

     

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

amitchandak's avatar
amitchandak
Super User
3 years ago

shaebert , You can get cumulative measure with help from date table 

 

example

Cumm = CALCULATE(SUM(Table[Value]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

 

or

 

Cumm = CALCULATE(SUM(Table[Value]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

shaebert's avatar
shaebert
Helper III
3 years ago

Below is an example of one of the two lines based on the table of data above. Hope this helps clarify what I meant.