Showing results for 
Search instead for 
Did you mean: 
Not applicable

Product Price Index

Hello Everyone,


Im trying to calculate a product price index. In my case a Avg. Rolling 12 month measure versus the Avg. Rolling 12 Month price  from 2 years ago (this is the tricky part for me, as my denominador has to be always the January of 2 years ago.)


Formula : (100) * ( Avg.R12M Dec 2018 price  / AvR12M January "2016"*)  


Where January 2016* is the comparison point of my index, and it will always be the start point equal to 100.


I having big problems with setting a dynamic denominator for this formula. it has to consider the actual Avg.12RM let say Dec 2018, and compare it versus the Avg.12RM price of January 2016. 


So basically i need to accomplish 3 steps:


1) Calculate a rolling 12 month of daily prices by product.

2) Create a dynamic measure as initial point of my index: set as January of  2 years ago.

3) Set the a dynamic Line graph that changes acording the denominador to display the correct versus "January" result.


The final formula would be  = (100) * ( Avg.R12M Dec 2018 price  / AvR12M January 2016*), but at the same time being dynamic enough, as next month 2019" it would move the denominator 1 year to become Avg.R12M January 2017.


Any help or suggestions?




Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors