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.
I have more than 1000 items lists - Any help would be really appreciated.
Items Date Actuals Forecast
| Number of Work Order | 18-Jan | 10 | |
| Number of Work Order | 18-Feb | 9 | |
| Number of Work Order | 18-Mar | 15 | |
| Number of Work Order | 18-Apr | 0 | 0 |
| Number of Work Order | 18-May | 0 | 0 |
| Number of Work Order | 18-Jun | 0 | 0 |
| Number of acquisitions | 18-Jan | 6 | |
| Number of acquisitions | 18-Feb | 8 | |
| Number of acquisitions | 18-Mar | 10 | |
| Number of acquisitions | 18-Apr | 0 | 0 |
| Number of acquisitions | 18-May | 0 | 0 |
| Number of acquisitions | 18-Jun | 0 | 0 |
| Number of capitalization | 18-Jan | 12 | |
| Number of capitalization | 18-Feb | 4 | |
| Number of capitalization | 18-Mar | 9 | |
| Number of capitalization | 18-Apr | 0 | 0 |
| Number of capitalization | 18-May | 0 | 0 |
| Number of capitalization | 18-Jun | 0 | 0 |
| Number of Work Order | 18-Jan | 10 | |
| Number of Work Order | 18-Feb | 9 | |
| Number of Work Order | 18-Mar | 15 | |
| Number of Work Order | 18-Apr | 16 | |
| Number of Work Order | 18-May | 0 | 0 |
| Number of Work Order | 18-Jun | 0 | 0 |
| Number of acquisitions | 18-Jan | 6 | |
| Number of acquisitions | 18-Feb | 8 | |
| Number of acquisitions | 18-Mar | 10 | |
| Number of acquisitions | 18-Apr | 14 | |
| Number of acquisitions | 18-May | 0 | 0 |
| Number of acquisitions | 18-Jun | 0 | 0 |
| Number of capitalization | 18-Jan | 12 | |
| Number of capitalization | 18-Feb | 4 | |
| Number of capitalization | 18-Mar | 9 | |
| Number of capitalization | 18-Apr | 15 | |
| Number of capitalization | 18-May | 0 | 0 |
| Number of capitalization | 18-Jun | 0 | 0 |
I have attached my excel spreadsheet along with this
