Forum Discussion
Running Total Week Calculation
Hi Community,
I hope this will be simple question, im trying to achieve what is calculation in column marked yellow:
So i have a table by Item number and by week both with supply and demand and i would like to write a measure showing me what is the stock level for each week (starting week should take Start Stock Value) and leter stock level should be calculated from previous week. is ist doable?
7 Replies
Hi mhsk ,
Below is the solution of a calculated column based on your data here. Maybe you have other conditions. Please reply to this.
Column = VAR currentWeek = [Week of Year] RETURN [Start Stock] + CALCULATE ( SUM ( Table1[SUPPLY] ) - SUM ( Table1[DEMAND] ), FILTER ( 'Table1', 'Table1'[Week of Year] <= currentWeek ) )
Best Regards,
OK, this will work pretty good while you have 1 item and week numbers dosnt duplicate. but what if table has many items and then many the same week's in column week of year. how can i tell power bi that im looking for this specific item context?
(if i apply this calculated column to data where more than one occurence of the same week exist then it crashes )
This is how it looks: So i would also need dax to know that we are looking at this item only and this week
