cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

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

2 REPLIES 2
Super User

@TimK , Are you using trailing month

Assume you have measure inflation or it Sum/ average

sum(Table[inflation ])

And Then have a measure

Helper III

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?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors