Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have values for 2 years, 2020 and 2021. In the previous year (2020), I calculate the simple variation of the accumulated of day X with the accumulated of the previous day X-1. With this amount, I make the product with the year 2021 and have a projection of values. I can calculate the predicted value for the following day but I can't calculate for the rest of the days and even if they accumulate, giving me an expected value for the end of the period and that's what I want. Can anyone help me with this?
LAST Var(%) = 35/32 = 1,09375 = 109,4%
Prediction = 25 * 109,4% = 27
Index | acum-2020 | var(%) | acum-2021 |
1 | 12 | 0,0% | 8 |
2 | 15 | 125,0% | 12 |
3 | 18 | 120,0% | 13 |
4 | 20 | 111,1% | 15 |
5 | 22 | 110,0% | 18 |
6 | 25 | 113,6% | 19 |
7 | 28 | 112,0% | 20 |
8 | 29 | 103,6% | 22 |
9 | 32 | 110,3% | 25 |
10 | 35 | 109,4% | 27 |
Totally incomprehensible. Please try to word your problem in a way that people can easily understand. Otherwise you're not gonna get any answers. Start with this, please:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
17 | |
14 | |
13 | |
13 | |
11 |
User | Count |
---|---|
19 | |
15 | |
15 | |
11 | |
10 |