cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

 

Sans titre.png 

2 REPLIES 2
Interkoubess Established Member
Established Member

Re: Cumulative sum by dates

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

Re: Cumulative sum by dates

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

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 210 members 2,498 guests
Please welcome our newest community members: