Accumulated column plus percentage of another column

[AndreDeLuca]

Hi, i need to create a measure, or a calculated column [meta], that returns the value of itself plus 15% of the [value] column.
I managed to create it in excel but i cant figure how i can do this in dax. Here's a print of the excel that i made:

Resuming, every row i need to accumulate 15% of [value] on my [meta] column. So the [meta] column would start being equal to the [value] column because 15% of 0 is 0, so there's nothing to accumulate.

Sorry for bad gramatics, hope you can understand.
Any help is welcome, 
Thank you.

[v-rzhou-msft · Accepted solution]

Hi @AndreDeLuca ,

I suggest you to add an index column in Power Query Editor and then create calculated columns by dax.

Calculated column:

15% = 
'Table'[value] * 0.15

meta = 
VAR _Start =
    CALCULATE ( SUM ( 'Table'[value] ), FILTER ( 'Table', 'Table'[Index] = 1 ) )
VAR _Accumulated =
    CALCULATE (
        SUM ( 'Table'[15%] ),
        FILTER ( 'Table', 'Table'[Index] < EARLIER ( 'Table'[Index] ) )
    )
RETURN
    _Start + _Accumulated

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AndreDeLuca]

Thank you my friend, you have solved my problem.

[parry2k]

@AndreDeLuca you need to use PRODUCTX function, check following two videos on my YT channel:

Calculate forecast production using cumulative weekly growth % on most recent actual production - Yo...

Calculate projected revenue based on compound growth rate - PowerBI - YouTube

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[AndreDeLuca]

Thank you for replying so fast!!
I kinda understood what you did in the video, you did something different from what i needed but i believe you will understand the solution i need.
In the video https://www.youtube.com/watch?v=9Mj592bSKq0 , is exactly what i need, except that the "projection" (meta as i called) needs to start especifically on october 2021 onward and cant go further than the present date because is a projection based on the last month rushed value.
I will try to explain to you the big picture, maybe it will help. There are 3 columns, [initial balance], [rushed value] and [reversed value]. Every month a value for each of these is produced. The initial balance was 0, and was incremented with the expression [rushed value] - [reversed value]. The new column or measure i need is the accumulate of the [rushed value] always growing 15% each month based on the [rushed value] of the month before, beggining on october 2021. This means that the [meta] value on the october 2021 row should return the same value as [rushed value] because there is no month before, and then start to accumulate 15% after this date, exactly how it shows on the excel table. 
Heres a print of the graph for better visualization, the light blue is [initial balance], darkblue [rushed value] and orange [reversed value].

You can observe that when the reversed value is greater than the rushed value, the initial balance decreases, and vice versa.

So looking at the table, the columns are: date ; rushed value(Valor Apurado) ; rushed value *0.15 ; meta.

Ignore the red line. So, what i want to show on the first row of META is the value of [rushed value] itself since there is no previous value for us to calculate 15%. I know is confusing but in a more practical way it means that the result on the green line (2nd row) is the sum of the blue and yellow line. And so on, the brown line should be the result of green line + pink line.

Im sorry for this much information, hope you could understand what i meant, i just really need to get this to work. 
Thanks for helping.