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. Cumul 90% = CALCULATE(SUMX('Liste sans prio','...
  • Amani's avatar
    3 years ago

    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