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...
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 |