SSAS Member Not returning CurrentMember Value

Hi All,

I have the Dimension


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?