Forum Discussion
Adding a Projection to Historical Data
Hello, I am looking to take historical QOH data & be able to add on a calculated future projection to a model. I've added a picture of a small example I created. I know the logic needed, but ca...
We are closer! Thanks!
Now, can we get the "Final POH" to be the Historical QOH for all past dates, and your projections for future dates?
Hi,
Here's a starting point. See page 2 of this file.
Ashish_Mathur amitchandak v-lionel-msft
Still not there. I need to be able to produce a table that looks like this, where QOH matches historically & projection is the last known historical inventory plus POs & Demand.Date Historical QOH (Measure) Demand (Measure) POs Landing (Measure) Final QOH (intermediary) 1/1/2019 1300 1300 2/1/2019 1200 1200 3/1/2019 1400 1400 4/1/2019 1450 1450 5/1/2019 1350 1350 6/1/2019 1000 1000 7/1/2019 1400 1400 8/1/2019 1700 1700 9/1/2019 1550 1550 10/1/2019 -250 210 1510 11/1/2019 -200 225 1575 12/1/2019 -245 285 1590