Hi All,
I have the Dimension
[Date].[Month]
And it has the values "2023-07","2023-08" and so on.. I am trying to get the current revenue but the [Date].[Month].CurrentMember does not work. It gives all and the latest value. I want to get 3 month prior revenue, but it returns null when the value is available in the cube.
I tried using ParallelPeriod and currentmember.lag but this does not work. Can you help with this?