Welcome everybody. It has been a quite a time since I visited forum last time. I have a problem and hope that you can help with it.
I need to introduce previous member value in MDX (e.g. previous week). I can write such a MDX Code:
([Date].[Week Year].CurrentMember.PrevMember,[Measures].[New Users])
It works fine with Week Year dimension. Although, when I filter it (with e.g. current week flag that I have in my model) then it cannot get previous member as this is filtered out. Same issue with Lag. Can anybody help me with resolving that issue.
With Regards