Forum Discussion
Solved
Prediction calculation
Hello, I tried to google and search in community, but I'm probably using wrong search words.. Can you please let me know what techniques / calculations should I use, if I would like to know in ...
KatkaS Well, you need to compute a linear regression to figure out your line I would imagine and once you have the linear formula values you can predict into the future: (2) Simple Linear Regression - Microsoft Power BI Community
Anonymous Thank you for your time!
I'm not able to attach files as I'm not super user, but I hope below table is enough to explain what I would need?
It is a simple excel with year, number of beekeper and beehives and I would need to know when (in the future) will be on the level of year 2015.
(I have data since 1990, but as an example less years are enough..)
Thank you again, I very much appreciate your help!
| Year | Number of beekeepers | Number of beehives |
| 2015 | 79 797 | 807 429 |
| 2016 | 78 456 | 766 466 |
| 2017 | 76 314 | 729 758 |
| 2018 | 73 401 | 685 324 |
| 2019 | 53 447 | 497 946 |
| 2020 | 54 416 | 528 186 |
| 2021 | 56 921 | 565 419 |
| 2022 | 57 380 | 540 705 |
amitchandak Would you perhaps know...? Thank you!!