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))