Forum Discussion
Prodruct 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, ...
Hi,
Share some data and show the expected result.
I'm not sure how to share data.
A mega link to PBI dummy date is : https://mega.nz/#!GGR12IAY!j4rB4ePWNDXI4QqOynlwVJbPEiPayGEVT53ZKjYP_gM
and the basic idea is I got the item prices in a daily basis, then I need to convert that into monthly avg, and 12RM monthly avg to finally compare it agains a baseline date. That basically is January of 2 years in the past.
Hi,
Sorry but i cannot understand your requirement. Could you show your expected result on an Excel file with formulas so that i can translate those Excel formulas into the DAX formula language.