Forum Discussion

TimK's avatar
TimK
Helper III
3 years ago

Compounding Inflation on a Monthly Basis

Hello,

 

I hope someone can help me please.......

 

I have a data table as below with Date and Inflation columns.  I need to calculate the Compound values at a monthly basis.

 

 

So basically, the figure in cell C26 is calculated by multiplying C14 x B26 and so on downwards; and C13 is calculated by dividing C25 / B13 and so on upwards

So cell C38 is calculated by multiplying C26 x B38

 

Thanks for any help

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    TimK , Are you using trailing month

     

    Assume you have measure inflation or it Sum/ average

    sum(Table[inflation ])

     

    And Then have a measure

     

    sum(Table[inflation])* calculate(sum(Table[inflation]) , dateadd(Date[Date],-1, Month))

     

     

    • TimK's avatar
      TimK
      Helper III
      3 years ago

      not sure if this will work, for example if i go out to 2026 - there will be 1.025^4

       

      so it compounds up on a similar monthy basis......

       

      so if we have

       

      Jan 22 1.00

      Jan 23 1.025

      Jan 24 1.025

      Jan 25 1.025

      Jan 26 1.025

       

      The values i would be after would be:

       

      Jan 22 1.00

      Jan 23 1.00 x 1.025

      Jan 24 1.00 x 1.025 x 1.025

      Jan 25 1.00 x 1.025 x 1.025 x 1.025

      Jan 26 1.00 x 1.025 x 1.025 x 1.025 x 1.025

       

      Does that make sense?