Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |