Price Impact Measure Help Needed
Hi, I am trying to create a measure that will help me determine the YoY Price Impact on a large number of items - So essentially, how has the Average Selling Price changed from Current Period to the Same Period Last Year. However, there are 3 variables that I need to consider. These being: 1) If Sales LY = 0 and Sales CY = 0, then return Price Impact of 0 (or blank) 2) If Sales > 0 but Quantity = 0, then return Price Impact of CY Price - LY Price 3) If Sales > 0 and Quantity > 0, then return Price Impact of (CY Price / CY Quantity) - (LY Price / LY Quantity) * LY Quantity I am relatively new to BI so would appreciate some help creating a measure that would allow me to complete this with all 3 variables above considered. I appreciate the help in advance. Thank you!