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 way and do some research and find out forecasting not support by table visual is there a way to find forecasting with Dax i'll add a example of data i need to forecast
Data look like this but i have 3 month data just showing example how data look like
i have some Question
1st:: is there Anyway to find forecast with power bi desktop
2nd::My company want that Forecast result on table visual same like table i'm shareing in this screenshot
3::Can i show show forecast result per site like site A, site B, site C
4::i use build in forecast option in power bi desktop but that's not giving me what i want
5::Don't want to use R visual any way i can find forecast value with Measure or any other way
thank you
8 Replies
- 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,
MFelixissue 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
MFelix
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
