I have below table coming out from power query after unpivot and i would like to develop formula to forecast automatically.
Below i have actual data for Jan, Feb and Mar (Number of WO) and i would like to forecast for Apr, May and June. During next month i will have actual data for 4months and need to foreacst for 2 months...
I have more than 1000 items lists - Any help would be really appreciated.
| Items | Monthly Baseline | Date | Actuals | Forecast |
| Number of Work Order | 5 | 1-Jan-18 | 2 | |
| Number of Work Order | 5 | 1-Feb-18 | 7 | |
| Number of Work Order | 5 | 1-Mar-18 | 8 | |
| Number of Work Order | 5 | 1-Apr-18 | 0 | 9.1071429 |
| Number of Work Order | 5 | 1-May-18 | 0 | 11.694221 |
| Number of Work Order | 5 | 1-Jun-18 | 0 | 11.720889 |
| Number of Customers | 10 | 1-Jan-18 | 5 | |
| Number of Customers | 10 | 1-Feb-18 | 4 | |
| Number of Customers | 10 | 1-Mar-18 | 8 | |
| Number of Customers | 10 | 1-Apr-18 | 0 | |
| Number of Customers | 10 | 1-May-18 | 0 | |
| Number of Customers | 10 | 1-Jun-18 | 0 | |
