Cumulative sum by dates

[AlexGallet01]

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"))

 

[Interkoubess]

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]

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])