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
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 figures
Monthly Figure =
VAR PreviousMonthValue =
CALCULATE (
SUM ( Table1[Cumulative] ),
FILTER (
Table1,
Table1[Year] = EARLIER ( Table1[Year] )
&& Table1[MonthNumber]
= EARLIER ( Table1[MonthNumber] ) - 1
)
)
RETURN
Table1[Cumulative] - PreviousMonthValue
JurriaanQEL
8 years agoRegular Visitor
Thanks a lot! Gonna work on this :manhappy: