Forum Discussion

AlexGallet01's avatar
AlexGallet01
Helper IV
8 years ago

Cumulative sum by dates

Hello,

 

I have a problem. When i try calculate a cumulative sum on two fiscale year, i have jsut one cumulative sum for one year.

 

The formula for the cumulative sum is :

 

Montant HT Cumulé test = CALCULATE(TOTALYTD(sum(Factures[Montant €]);'Date'[Date];"30/06"))

 

 

Need Help

2 Replies

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    Hi AlexGallet01,

     

    Formulae with YTD are based on a yearly calculation, that means it takes only calculation on a yearly basis.

    If you want a cumulative sum then you might use another approach.

     

    Could you please share dummy data with your expected results and we will give it a try?

     

    Ninter

    • AlexGallet01's avatar
      AlexGallet01
      Helper IV
      8 years ago

      Hello,

       

      Sorry i don't have test data bases. If i do undestand you think i must use another function for do this cumulative sum. 

       

      It's possible to have many different result with SELECTEDVALUE ?

       

      CALCULATE(sum(Factures[Montant €]);Date[AnnéeFiscale] = SELECTEDVALUE[anneechoisi])