Fill Null Values in Query with previous dates value

Fill Null Values in Query with previous dates value

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

SELECT DISTINCT
 "Period" AS  'Date',
 "Running Expense" AS 'Expense',
 "Marketing Burn Budget" AS 'Budget',
 500000 -"Running Expense" 'Burndown'
FROM  "Query 2023 Marketing P&L"  
JOIN  "Marketing Burn Down Budget -  Daily 2023" ON "Period" ="Posting Date"
WHERE  "Period"  >= "Posting Date"
 AND "Period"  <= "Posting Date"
 AND "Marketing Burn Budget"  > 0
      Bootcamp
      Community
      Pricing
      Webinars
      What's New
      Integrations
      Contact Support
      Contact Sales



          Zoho Survey Resources
            Features
            Survey Templates
            Integrations
            Community
            iOS Mobile Surveys
            Pricing
            Android Mobile Surveys
            Insurvey Blogs
            Insight Blogs
            Tips & Tricks





                          Setup Zoho Bigin in 30 Minitues
                          Latest Feature Updates

                            Zoho Desk Resources

                            • Desk Community Learning Series


                            • Digest


                            • Functions


                            • Meetups


                            • Kbase


                            • Resources


                            • Glossary


                            • Desk Marketplace


                            • MVP Corner


                            • Word of the Day




                                Zoho Marketing Automation
                                  Zoho SalesIQ Resources


                                        Manage your brands on social media
                                        Access Zoho Social

                                          Zoho Pagesense Resources


                                                Zoho TeamInbox Resources

                                                  Zoho DataPrep Resources



                                                    Zoho CRM Plus Resources

                                                      Zoho Books Resources


                                                        Zoho Subscriptions Resources

                                                          Zoho Projects Resources


                                                            Zoho Sprints Resources


                                                              Qntrl Resources


                                                                Zoho Creator Resources


                                                                  Zoho WorkDrive Resources



                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series


                                                                      • Tips

                                                                        Tips

                                                                      • Functions

                                                                        Functions

                                                                      • Meetups

                                                                        Meetups

                                                                      • Kbase

                                                                        Kbase

                                                                      • Resources

                                                                        Resources

                                                                      • Digest

                                                                        Digest

                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner

                                                                      





                                                                      




                                                                          Design. Discuss. Deliver.

                                                                          Create visually engaging stories with Zoho Show.

                                                                          Get Started Now