How Can I Get Lastest Value

I have a table for Units and Dollars based on 2 date keys ; snapshot date_key and delivery date_key (which are date key from date dimension)

This table do not update daily and if I want to have the information based on the lastest snapshot date_key how should I write a query for this case?

What I did was:





Code Snippet

SELECT snapshot_date_key,delivery_date_key, units, dollars
FROM dbo.tbl_fact
WHERE snapshot_date_key IN(SELECT DATE_KEY FROM tbl_DIM_Date
WHERE (FULL_DATE = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))))





But this query is only available when snapshot date key exists in the table based on today.
If table is not updated today then I want to get the lastest snapshot_date_key from the fact table.
Max function with sanpshot_date_key does not work due to the delivery_date_key.

And kinds of advice would be greatly appreciated.
Thanks.