How to calculate weekly running opening stocks?

[Yazar]

Hi Folks,

my supply planning file done in excel. now i am trying to move in to Power bi for better visualisation in inventory and for easy analysis.

i have following data set. can you pls help me to set it up opening stocks by DAX?

Opening stock in wk20 - is data input from stock table

Forecast , confirmed delivery, expected orders to place are  input from different table

closing stock is calculated field which has calculated as follows

wk20 closing stock = wk 20 Opening stock + wk20 confirmed delivery + wk20 expected orders to place - wk20 forecast

wk21 opening stock = wk20 closing stock

same is rolling out for future weeks.

i want to set it up this in PBI to get closing stock in wk20 and opening stock in wk21 to show in visual.

can any one please help me on this?

[Anonymous]

https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-...