Forum Discussion
Solved
running total in calculated column
Hi all, My data model contains a table with planned changes in stock per item. I want to add a column to this table which contains the accumulated stock changes for this item until the date of th...
Hi AlB,
Thanks for your quick reply!
Here is simplified structure of my fact table. It contains various items which have multiple planned changes. There can be several changes on the same item at the same date (see line 4 and 5). In order to calculate the planned stock level at the date shown on the current row, I want to sum all changes until the date in the current row. The Running Total column shows the desired result. FYI: date format is d-m-yyyy
I hope you can help me with this.
OK, try this:
RunningTotal =
CALCULATE (
SUM ( Table1[Movement] ),
Table1[Date] <= EARLIER ( Table1[Date] ),
ALLEXCEPT ( Table, Table1[Item] )
)
It's always good to show your sample data also on table/text format so that it can be readily copied