Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
YasirBilal
Helper I
Helper I

Is my forecast value right

Hello Everyone

 

So i want to ask i use power bi desktop line visual to do forecasting the result i get 

that's only one site data i'm sharing i do forecast for 819 site some of them giving me this issue not all 

 

 

Month         Total             forecastValue
1/1/2017      40000
2/1/2017      32000
3/1/2017      40000
4/1/2017      40000
5/1/2017      40000
6/1/2017      40000
7/1/2017      56000
8/1/2017      48000
9/1/2017      48000
10/1/2017    48000
11/1/2017    32000
12/1/2017    64000
1/1/2018      48000
2/1/2018      48000
3/1/2018      40000
4/1/2018      56000
5/1/2018      56000
6/1/2018      32000
7/1/2018      48000
8/1/2018      48000
9/1/2018      56000
10/1/2018    48000
11/1/2018    40000
12/1/2018    32000
1/1/2019      32000
2/1/2019      24000
3/1/2019      0
4/1/2019     8000
5/1/2019    15791.2
6/1/2019    8000
7/1/2019    0
8/1/2019    0
9/1/2019    0
10/1/2019    0
11/1/2019    0
12/1/2019    0
1/1/2020                      -4171.365423
2/1/2020                      -7081.240127
3/1/2020                      -14758.11214
4/1/2020                       690.922017
5/1/2020                       6299.942931
6/1/2020                     -10170.33298
7/1/2020                     -1859.007765
8/1/2020                     -2250.080454
9/1/2020                        2120.82186
10/1/2020                    725.6093023
11/1/2020                   -6635.075564
12/1/2020                    2119.905997

 

So first of all i'm getting negivate value not sure if that's right i use build in forecast function

 

2nd when i show this forecast value to my boss he said the value is wrong as well value should not be negivate

 

3rd is this because of 0 value i have against some months

 

can anyone share some thoughts on this

 

thank you

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

A good forecast needs good data. Stop total at 2/1/2019 and then forecast. Post that values are creating wring picture

 

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

A good forecast needs good data. Stop total at 2/1/2019 and then forecast. Post that values are creating wring picture

 

So 0 giving me issue is that right

 

It seeing a trend that data become 0 and continue. so the will result in getting negative value.

 

thank you 

understand your method work for me 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.