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 ...