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