Forum Discussion
Helper IForecasting in Power Bi Desktop
Super UserIt'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
Helper Iissue 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
- MFelixHi YasirBilal,
That as no importance you I was just giving examples rules can be defined as you want.
Regards
MFelix- YasirBilal
okay i'll try this way thank you for answer
v-xuding-msftCommunity Support
Hi YasirBilal ,
Did you calculate out the forecasting values? If you solved it, please share your solution here. Others who have the same requirement will benefit here. If you are still confused it, maybe the following blogs will help you.
https://www.sqlbi.com/articles/showing-actuals-and-forecasts-in-the-same-chart-with-power-bi/
https://community.powerbi.com/t5/Desktop/Finance-Forecast-using-DAX/td-p/318862
https://blog.enterprisedna.co/forecasting-techniques-in-power-bi-by-using-dax/
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.