Cumulative Column

[Amani]

Hello,

I want to create a calculated column containing the cumulative premiums order by date. I tried many formula, but the result is not correct.

1. Cumul 90% = CALCULATE(SUMX('Liste sans prio','Liste sans prio'[Primes]),FILTER('Liste sans prio','Liste sans prio'[Date déport]<=max('Liste sans prio'[Date déport])))
2. Cumul 90 % = calculate(sum('Liste sans prio'[Primes]),'Liste sans prio'[Date déport]<=MAX('Liste sans prio'[Date déport]))
3. Cumul 90 % = calculate(

   sum('Liste sans prio'[Primes]),

   DATESBETWEEN('calendar'[Date].[Date],FIRSTDATE('calendar'[Date].[Date]),LASTDATE('calendar'[Date].[Date])))

   Calendar is a table date

   

Result first formula :

Result Second and Third Formula :

Best regards.

[Amani · Accepted solution]

I solved the problem by using this formula :

Cumul 90 % = calculate(

sum('Liste sans prio'[Primes]),

filter('Liste sans prio','Liste sans prio'[Date déport]<=EARLIER('Liste sans prio'[Date déport])))

Thx