Forum Discussion

Sam_S007's avatar
Sam_S007
Copper Contributor
Oct 19, 2020

Using Power Query Editor to Match Dates for Two Time Series

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.

No RepliesBe the first to reply

Resources