Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

apply a compounding interest rate

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 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    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)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Perfect! You are genious.  Thanks much.