Forecasting in Power Bi Desktop

[YasirBilal]

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 

[MFelix]

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

[YasirBilal]

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

[YasirBilal]

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

[MFelix]

Hi @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-msft]

Hi @YasirBilal ,

Could you tell me if you have calculated out the forecasting values? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

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.

[YasirBilal]

Sorry for late reply i been busy

Yes i Do  calculated Forecasting i use the build in Visual Forecasting i come to find out company giving me wrong data for Forecast when i got right data i use the Power bi build in function to do forecast

[v-xuding-msft]

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.