Cumultive data for 3 different years on the same graph

[jsteffe]

Hello,

I get a table with a column Date and a column numberOfParticipants
I want to design the graph below :

I want to get the cumulative sum of numbers per month for my all 3 years.

Thanks for your help.

[harshnathani]

Hi @jsteffe ,

You can try

Measure = SUMX (
    FILTER (
        ALLSELECTED ( Table1[Date] ),
        Table1[Date] <= MAX ( Table1[Date] )
    ),
    [Total Participant]
)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[jsteffe]

Thanks for your reply.
It partially  works because with this measure, I get the following graph and using my segments, I can see the graph for each year.

But how can I get the 3 curves on the same graph (one for 2019, one for 2020, one for 2021) ?

[rsbin]

@jsteffe,

If you have a Year column, you should be able to drag that field into your Legend well.

[jsteffe · Accepted solution]

If I add The Year column in the legend, I get :

For year 2020, it cumulates the numbers of 2019 and 2020.
As I don't want to cumulate, amitchandak suggested to create 3 measures :

YTDnb = CALCULATE(SUM(Stages[nbParticipants]),DATESYTD('Calendar'[Date],"12/31"))

YTDnb-1 = CALCULATE(SUM(Stages[nbParticipants]),DATESYTD(dateadd('Calendar'[Date],-1,Year),"12/31"))

YTDnb-2 = CALCULATE(SUM(Stages[nbParticipants]),DATESYTD(dateadd('Calendar'[Date],-2,Year),"12/31"))

and then I get the good result :

Thanks to you rsbin and to amitchandak for your great help ...