topic Re: Inventory management (actuals and forecast combined) in DAX Commands and Tips

Inventory management (actuals and forecast combined)

tonvhemert3 — Wed, 14 Jun 2023 07:45:24 GMT

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

Re: Inventory management (actuals and forecast combined)

Anonymous — Thu, 08 Jun 2023 04:55:14 GMT

Hi tonvhemert3 ,

You can view the contents of the following PBIX file:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Inventory management (actuals and forecast combined)

tonvhemert3 — Thu, 08 Jun 2023 07:31:50 GMT

Hi Liu Yang,

Thanks for the post. However, this is not really what I am looking for. It should be a table in the "Report view" and if future values get added, it should work as well.

Kind regards,

Ton