Show previous month data on current month selection

[skzwane01]

Hi,

I have a dataset of employees per month. I have to create an opening balance expression which is: the closing balance of the previous month. Please see examples below:

Sept 2020 Closing Balance = 200

Oct 2020 Opening balance = 200 and Closing Balance is 250.

Nov 2020 Opening Balance = 250 and Closing Balance is 230.

Dec 202 Opening Balance = 202 and Closing Balance is 200

Hope this makes.

Your assistance is highly appreciated.

Kind Regards

[jwjackso]

You can calculate the [Opening Balance] as Above ([Closing Balance])

[skzwane01]

Thanks it works!!! It is actually the "Before" function.

How do I now show the first months data? If you look at the below example, 202011 has no value based on the current selection, how do I show the 202010 closing balance as the 202011 Opening balance?

The expression is as below: