Compounding Inflation on a Monthly Basis

[TimK]

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

[amitchandak]

@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]

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?