Hello,
I have a question regarding copying the date within a model.
I have a dimension Period, which is a generic dimension, not a Date one, and I need to move/shift data in bulk like on the schema below:

How is it possible to do with Advanced Formulas? I cannot use NEXT() as Period is not a Date dimension.
The Period dimension is ordered/sorted, I created a property OrderN which contains an order number of the given member. But how can I use this property in Advanced Formulas to get the required result?
Please, advise!
Yuri
P.S. Or maybe there is a different approach without using dimension properties?