Inventory management (actuals and forecast combined)
Hello, I'm trying to create the following table in PowerBI. It should work as following: Jan Feb Mar Apr May Jun Jul Aug Sep Okt Nov Dec 1. Starting Inventory 20.000 25.000 35.000 25.000 35.000 40.000 45.000 55.000 45.000 25.000 45.000 35.000 2. Production 10.000 20.000 15.000 30.000 40.000 50.000 40.000 30.000 40.000 40.000 30.000 25.000 3. Sales (forecast) 5.000 10.000 25.000 20.000 35.000 45.000 30.000 40.000 60.000 20.000 40.000 30.000 4. Closing Inventory 25.000 35.000 25.000 35.000 40.000 45.000 55.000 45.000 25.000 45.000 35.000 30.000 1. Starting inventory = StockCount[StockCount] if the month is in the past and it should be equal to the previous month Closing Inventory for the future. 2. Production = Production[Production] 3. Sales (forecast) = Sales Actuals[sales(actuals)] if the month is in the past and it should be Sales Forecast[sales(forecast)] if the month is currently active or in the future. 4. Closing Inventory = Starting inventory + Production - Sales (forecast) I can't share the PBIX file here yet, since I am a fairly new member. However, I can share the file by WeTransfer: https://we.tl/t-OmfofN6WoQ