Previous on Custom Date
Assuming the Model's requirement is a monthly time dimension. However, the Cashflow Forecast requires input for every 7 days, or weekly set up. Is there a way for the previous date ending cash to be roll forwarded to the next date's beginning balance like this illustration below since I cannot use my previous, lag or movingsum on this?
Appreciate your answers.