Forum Discussion
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 basi...
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))
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?