The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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