Hi Team,
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.
Thanks,
Elaine