Show value for date previous to what is displayed on the Dimensional Report

[ML]

Hi,
I have a report based on a dimensional cube.  I want to add a new column called 'Closing Balance' to display the Raw Average figure.
The closing balance for the previous date is the opening balance of the date displayed on the report.
ie Opening Balance for 2020-02-26 equals 21,352.  Therefore the 'Closing Balance' for the previous date 2020-02-25 equals 21,352.

I have a dimension in my report called Historian_Current_Month and I am displaying the date level which is level 2 of the dimension.  The Member set name in the report is Current_Month.  Set definition for this is...
descendants([Historian_Current_Month],2)

Thank you

[Andrei I]

Can you add an example of a layout you need?