LIONEL CHARLEY
New Member
- Joined
- Nov 8, 2010
- Messages
- 1
Items | Date | Actual | Forecast |
# of Work Order | Jan | 5 | |
# Of Work Order | Feb | 7 | |
#of Work Order | Mar | 3 | |
# of Work Order | Apr | 0 | ? |
# Of Work Order | May | 0 | ? |
# of Work Order | Jun | 0 | ? |
<tbody>
</tbody>
I have above table coming out from power query after unpivot and I would like to develop formula to forecast dynamically, As you can see in the above, we have # of Work Order from Jan to Mar and would like to know what is the forecast for April to Jun. Similarly after the next month we will have 4 month of actual and would like to predict for last two months. Is there any formula we can use.
My goal is plot actual and forecast through a line chart