Forum Discussion
JurriaanQEL
8 years agoRegular Visitor
Remove cumulative total
Hi, Every month I receive a file with updated numbers. One of the columns is cumulative, e.g.: January - 20 February - 25 March - 40 I want to have a table in Power ...
- 8 years ago
Hi JurriaanQEL
Please see the attached file here.
Hope this helps. Here are the steps I performed
As you said we need an assistant field to undo the Cumulatives. So
First I created a "Parameter Table" to get "month number" in our Main Table
Then we can use this Calculated Column to get Monthly figuresMonthly Figure = VAR PreviousMonthValue = CALCULATE ( SUM ( Table1[Cumulative] ), FILTER ( Table1, Table1[Year] = EARLIER ( Table1[Year] ) && Table1[MonthNumber] = EARLIER ( Table1[MonthNumber] ) - 1 ) ) RETURN Table1[Cumulative] - PreviousMonthValue
Zubair_Muhammad
Community Champion
8 years agoHi@ JurriaanQEL
Could you please copy paste sample data just like in the post you referred to?
Do you have other columns beside month and amount?