apply a compounding interest rate

[Anonymous]

Hello,

I am attempting to project budget amounts for multiple years using a compounding rate increase which I will control using a parameter.

My data set looks like:

Year Budget (all the same based on base year)

2019 $XXX,XXX

2020 $XXX,XXX

2021

2022

2023

2024

2025

Here is my base formula that I cannot get to work. All thoughts are welcomed.

Annual Budget Increase2 = [2019 Budget]

    * POWER (

        1 + 'Projected Annual Budget Change'[Projected Annual Budget Change],

DATEDIFF (

            CALCULATE (

                FIRSTDATE ( 'Budget'[Year] ), LASTDATE('Budget'[Year]),

            'Budget',

            YEAR

        )

    ))

Thanks much.

[Greg_Deckler · Accepted solution]

See Page 3, Table 13

Measure 7 = 
VAR __2019Budget = MAXX(FILTER(ALL('Table13'),[Year]=2019),[Budget])
VAR __currentYear = MAX([Year])
VAR __minYear = 2019
RETURN
__2019Budget * POWER(1+[Rate Increase], __currentYear - __minYear)

[Anonymous]

Perfect! You are genious.  Thanks much.