I am new to the Forum and was hoping that I could get some guidance on where to look to solve a piece of the puzzle I have been working on.
I work in Supply Chain and have been asked to build a tool in Power BI that functions as an MRP.
The goal of the tool is to forecast an inventory value based on several variables over the forecast horizon. I have been working on the concept with simple numbers and would like to apply it to the real data set.
The equation is as follows:
Current Inventory - Demand + On Order = Ending Month Invetory
Ending month Inventory = Current Inventory for the next period - this has been the piece I have not been able to work out. I keep running into a circular reference issue.
Is this discussed in a video on the sight or has someone run into this problem before?
One observation, you have a massive Date table, if at all possible restrict that to the number of years you actually require. Because some calcs are now iterating over a very large Date table.
You could for example set up a dynamic start- and enddate for your date table, here’s more on that.
Next I created a couple of measures:
This calculates the last ProductPlanning[Date ] with an inventory value.
This is based on your illustration of having only one initial stock position.
Here’s my sample file. I hope this is helpful. eDNA - MPT Tool Test_Share.pbix (711.3 KB)
Hi @myassay75, we hope that you are having a great experience using the Support Forum so far. We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!