Show latest value for missing rows

Hi,

I have a table looking something like this, where each entry has the date when the revenue for a specific store during a perticulare period was updated. For clariry, the period is the actual timeframe and the date modified is the date where a person (lets say accountant) actually entered that value. Sometimes the date modified is before the period meaning that it is an estimate for the revenue at that time. 

My problem is that I want to show what the estimation/actual revenue was at a specific date (date modified).

Even though a specific field might not have been updated. For example store S2 was not updated 2023-02-02 however I still want to show the latest value i.e the value from 2023-01-01 giving me something like this:

How could I solve