I am trying to combine two tables so I can create a burndown report for marketing budget

One Table is "Marketing Burn Down Budget -  Daily 2023" which is just a table that contains each day of the year, and starts at $500k then drops incrementally each day until the budget depletes on 12-31-2023

The Second table is "Query 2023 Marketing P&L"  and this budget pulls expenses from an expense report by cost center, so it only contains sum total of marketing expenses per day (represented as a sum number, not individual expenses).

The issue I am having, is when I join these two reports by their corresponding dates, even though the marketing budget report has a value for every single day of the year, when they are joined the query only shows values for the days that dont have a null value from the expense report. How do I make this query show values for every day, including the days with null expense values, but instead show the value from the prior day if the value is null?

EXAMPLE:

The table below is how transactions might occur in reality since money isn't spent everyday

But the table below is how Zoho Query is representing the data

And how I want it actually represented is like the table below

Thanks