Oct 19 2020 10:27 AM
I have two different daily frequency time series (crude oil and the dollar index). But the dates don't match. I want to match the dates for them so I can plot them on the same graph. Can I use Power Query Editor to match the dates? I want to use all the dates for crude oil and just back fill data for the dollar index if they are missing.
I attached a copy of the spreadsheet.