Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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% |
Solved! Go to 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
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.
@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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |