Forum Discussion
Need help in forecast data in Power Query
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 |
3 Replies
You could create measures to forecast data in the coming months,
from infromation you provided, it is not very clear about the rule for foracasting.
Please provide more details.
Best Regards
Maggie
Hi Maggie,
Is there a way to forecast based on actuals, could you give some hint about the measure..
