Forum Discussion

Amani's avatar
Amani
Frequent Visitor
3 years ago
Solved

Cumulative Column

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.

 

 

  • 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

1 Reply

  • Amani's avatar
    Amani
    Frequent Visitor

    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