Forum Discussion
Future Inventory Forecasting in Power BI
Hello everyone, I’m working on a Power BI report to forecast future inventory values based on current inventory, purchase orders, production orders and requirements. I’ve encountered a challenge in ...
amitchandak
Super User
Super UserAnonymous , You need have common date and Material table and then you should be able to use the Measure you need across tables
example , table can be different in this case in each calculate
Inventory / OnHand =
CALCULATE(firstnonblankvalue('Date'[Month]),sum(Table[Intial Inventory]),filter(all(date),date[date] <min(date[date]))) // only first value
+
CALCULATE(SUM(Table[Ordered]),filter(all(date),date[date] <min(date[date]))) -
CALCULATE(SUM(Table[Sold]),filter(all(date),date[date] <min(date[date])))
Power BI Inventory On Hand: https://youtu.be/nKbJ9Cpb-Aw
or refer
https://radacad.com/calculating-stock-on-hand-using-dax-power-bi-inventory-model