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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Calculate the total accumulated within the same measure

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

 

Indexacum-2020var(%)acum-2021
1120,0%

8

215125,0%12
318120,0%13
420111,1%15
522110,0%18
625113,6%19
728112,0%20
829103,6%22
932110,3%25
1035109,4%27
1 REPLY 1
Anonymous
Not applicable

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

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.