I have created a calculation called Prior Year Price Actual or ([PY Avg Price : Act]).

Now I have been given the requirement to create another calculation, Prior Year Price Actual or ([PY Avg Price : Act]) by PERIOD.  How can I adjust the query to complete this task. The new calculation would be named Prior Year Period.

Hi D Henson,

According to your description, you want to create a calculated measure to get the Price Actual for corresponding Period. Right?

In this scenario, since you already have an average measure for Prior Year, you just need to do same aggregation on Period level(I assume you are using Quarter). So you can modify the expression like:

Aggregate(
ancestor(
parallelperiod([Date].[Calendar].[Calendar Year],1,
[Date].[Calendar].currentmember),
[Date].[Calendar].[Calendar Quarter]),
[Measures].[Avg Price Actual]
)

Reference:
Ancestor (MDX)

Regards,