Using Power Query Editor to Match Dates for Two Time Series

Occasional Contributor

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.

0 Replies