Forum Discussion

jsteffe's avatar
jsteffe
Icon for Helper III rankHelper III
4 years ago
Solved

Cumultive data for 3 different years on the same graph

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.   Tha...
Need Help
  • jsteffe's avatar
    jsteffe
    4 years ago

    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 ...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    jsteffe
    Icon for Helper III rankHelper III
    4 years ago

    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's avatar
      rsbin
      Icon for Community Champion rankCommunity Champion
      4 years ago

      jsteffe,

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

       

      • jsteffe's avatar
        jsteffe
        Icon for Helper III rankHelper III
        4 years ago

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