Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |