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','Liste sans prio'[Primes]),FILTER('Liste sans prio','Liste sans prio'[Date déport]<=max('Liste sans prio'[Date déport])))
- Cumul 90 % = calculate(sum('Liste sans prio'[Primes]),'Liste sans prio'[Date déport]<=MAX('Liste sans prio'[Date déport]))
- 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
- AmaniFrequent 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