Last value of previous month
I have requirement, where I need to get the last value of the previous month and put in all the records of the current month.
If you see in the attached screen shot, i have Income MTD which is a formula and I want to calculate Prior Month MTD. For that I need to get the last value of Prior Month and coppied to all the dates of current month.
So can someone guide me how to get last value of the prior month.