% Cumulative inflation

[Syndicate_Admin]

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%

[Syndicate_Admin]

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.

[amitchandak · Accepted solution]

@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