Forum Discussion
Amani
3 years agoFrequent Visitor
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','...
- 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
Amani
3 years agoFrequent 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