Carry forward Value from previous week to the next week

[kulkarnipriya87]

I have Measure for opening inventory, Closing Inventory and forecast.
If in week 3 my opening inventory is 10, Forecast is 2 and cIntransit is 5 then
According  to formula 10 + 5 - 2 = 13.
13 is my Closing inventory.

Now I want 13 is the opening inventory for the next week.
Closing inventory of previous week is the opening inventory of the next week.

Material code	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
Opening  inventory	(Factory inventory+To factory+OIPL inventory)	(Opening inventory +Intransit inventory -Forecast)	10	13	28	0	0	0	0	0	0	0	0	0	0	0	0
Forecast	From forecast file		2	5
Intransit	From PO tracker (Tentative ETA- cloumn AD from PO tracker)		5	20	30
Closing inventory	(Opening inventory +Intransit inventory -Forecast)		13	28

[kulkarnipriya87]

@Greg_Deckler
Can you help with this?

[lbendlin]

OK. What is your question?

(Note that Power BI doesn't like these kinds of wide tables, you will want to unpivot the data for easier processing.)

[kulkarnipriya87]

My weeks are calculated fields.
[Opening Inventory] and [Closing Inventory] are my calculated measures.
Now, I want to display it in this format.
Suppose the closing inventory this week is 10 then 10 should reflect the opening inventory in the next week.

Opening Inventory = Closing inventory of the previous week.

[lbendlin]

Use List.Accumulate in Power Query or SUMX in DAX to achieve this desired result.

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[kulkarnipriya87]

https://www.dropbox.com/s/dvp8qpe6l5zcnsn/Sample_Data_For_Community.pbix?dl=0

PBIX file


Source Files -
https://www.dropbox.com/scl/fi/q9k5etfhmrinz8cne94jc/Forecast-Master.xlsx?dl=0&rlkey=cq502wxk103ji41...
Forecast Master

https://www.dropbox.com/scl/fi/5ppgt96uey2mx09dw9sre/Inventory.xlsx?dl=0&rlkey=g0v1sn4afpg8hkb0h7vpl...
Inventory

https://www.dropbox.com/scl/fi/ggog23ch3mqinmwj3l9uu/POTracker.xlsx?dl=0&rlkey=oavo3ra1q1hbvm9mp84wh...

POTracker

[lbendlin]

Please explain the table relationships.  A standard Power BI data model prefers 1:* connections that are single directional.  Yours looks more like a Qlik model.