Price Elasticity

hi, FischerEric86

try this one:

SelectedPeriod = SELECTEDVALUE('DateTable'[YearMonth])

Period_Back1 = SELECTEDVALUE('DateTable'[YearMonth]) - 1
Period_Back2 = SELECTEDVALUE('DateTable'[YearMonth]) - 2
Period_Back3 = SELECTEDVALUE('DateTable'[YearMonth]) - 3

Period_Forward1 = SELECTEDVALUE('DateTable'[YearMonth]) + 1
Period_Forward2 = SELECTEDVALUE('DateTable'[YearMonth]) + 2
Period_Forward3 = SELECTEDVALUE('DateTable'[YearMonth]) + 3

InitialQuantity =
CALCULATE(
SUM(Sales[Quantity]),
'DateTable'[YearMonth] IN { [Period_Back1], [Period_Back2], [Period_Back3] }
)

NewQuantity =
CALCULATE(
SUM(Sales[Quantity]),
'DateTable'[YearMonth] IN { [Period_Forward1], [Period_Forward2], [Period_Forward3] }
)

InitialPrice =
CALCULATE(
AVERAGE(Sales[Price]),
'DateTable'[YearMonth] IN { [Period_Back1], [Period_Back2], [Period_Back3] }
)

NewPrice =
CALCULATE(
AVERAGE(Sales[Price]),
'DateTable'[YearMonth] IN { [Period_Forward1], [Period_Forward2], [Period_Forward3] }
)

PriceElasticity =
DIVIDE(
(([NewQuantity] - [InitialQuantity]) / ([NewQuantity] + [InitialQuantity]) / 2),
(([NewPrice] - [InitialPrice]) / ([NewPrice] + [InitialPrice]) / 2)
)