I would do something like this. I created a dummy table with data similar to what you explained. So for dates that don't have a conversion factor the last available date's conversion factor should be copied over to the rest of the dates(If i understood correctly).
Hope it helps
Test8.qvw 146.8 K