Hi, thanks for your answer.

Yes you are right, it's a YOY measure that should be available for the last two years.

If a store opening date is newer as today minus two years is filtered out.

The complicated cases are combinations of different attributes, i.e. a store that was close during one week due to a refurbishment. If the close occurred this year I have to block the same period last year, but still be able to compare the other weeks and the levels above.

We also have a fiscal calendar and a retail calendar and the YOY has to work for both.

I'm just wondering if there are better ways to implement it.

I saw today an answer in a forum that proposes a calculated member with MDX subqueries, but it proofs if there are transactions in both periods. This solution only considers the transactions and not the store attributes. The disadvantage, appart from the performance, is when a store was open but has not made any sales.

Kind regards,