Forum Discussion
Prediction calculation
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
Greg_Deckler Thank you, Greg, for your prompt reply! I tried to reproduce the measures from your link, but it doesn't give me the reply I would need - I would need to know at which year we will be on numbers from 1990 (807 429 beehives), currently we are at 694 094 for 2020 and we see increasing trend, which doesn't make sense? But the linear trend line shows decreasing trend.. I'm attaching the pbix file as well and I'm sorry, but most of it is in czech as I have it for my data academy course and it has to be in czech (I translated measures for below graph to english).