Forum Discussion
Forecasting in Power Bi Desktop
Hello Everyone So My Question is is there any way to show forcasting result on table visual i do know about forecasting on line chart but my company want forecast result on table visual i try many w...
Hi YasirBilal,
It's possible to create a measure that forecast your values however you need to define what are the rules you need in order to have the calculation made.
You can have your forecast being an average of the previous year value, or of the rolling average, or equal to previous year or increase by x% and so on.
Regards,
MFelix
It's possible to create a measure that forecast your values however you need to define what are the rules you need in order to have the calculation made.
You can have your forecast being an average of the previous year value, or of the rolling average, or equal to previous year or increase by x% and so on.
Regards,
MFelix
issue is i don't have whole year data only 3 month repeat again and again per site i do show how my data look like
- Hi YasirBilal,
That as no importance you I was just giving examples rules can be defined as you want.
Regards
MFelixokay i'll try this way thank you for answer
Also the data i have have no pervious year or month data only 3 month with current year (2019) sale have to calculate forecast with 3 month sale
