Forum Discussion
% 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% |
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
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
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.
