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

## % Cumulative inflation

I have the following table with the monthly inflations of each period. I need to create an accumulated measure, to calculate the % of inflation accumulated to each month. What I would need is that when selecting a certain period, I mark the accumulated inflation of that entire period. For example if filter selecting 8 months, check the accumulated inflation of those 8 months, and so on.
I would also like to have an option that when selecting a certain month, throws me the accumulated inflation of the last 12 months, from that month selected individually.

 Period % inflation one-20 3,70% feb-20 2,30% mar-20 2,00% Apr-20 3,30% may-20 1,50% June 20 1,50% jul-20 2,20% ago-20 1,90% sep-20 2,70% oct-20 2,80% nov-20 3,80% Dec-20 3,20% one-21 4,00% feb-21 4,00% mar-21 3,60% Apr-21 4,80% may-21 4,10% June 21 3,30% jul-21 3,20% ago-21 3,00% sep-21 2,50% oct-21 3,50% nov-21 3,50% Dec-21 2,50% one-22 3,80% feb-22 3,90% mar-22 4,70% Apr-22 6,70% may-22 6,00% June 22 5,30% jul-22 5,30% ago-22 5,30% sep-22 5,30%
1 ACCEPTED SOLUTION
Super User

@Syndicate_Admin , with help from a date table you can have measure like, assuming inflation is the column

Rolling 12 = CALCULATE(Average(Table[inflation %]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

here 12 can be coming from a what if parameter

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Rolling Months Formula: https://youtu.be/GS5O4G81fww

2 REPLIES 2

I have the same interest. Were you able to solve it somehow? I can't find how to make it so that the user can opt for the base period in which inflation begins to accumulate. What I found in the forum only shows to calculate inflation for all rows of the table.

Super User

@Syndicate_Admin , with help from a date table you can have measure like, assuming inflation is the column

Rolling 12 = CALCULATE(Average(Table[inflation %]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

here 12 can be coming from a what if parameter

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Rolling Months Formula: https://youtu.be/GS5O4G81fww

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 - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors