Using Power Query Editor to Match Dates for Two Time Series

%3CLINGO-SUB%20id%3D%22lingo-sub-1796450%22%20slang%3D%22en-US%22%3EUsing%20Power%20Query%20Editor%20to%20Match%20Dates%20for%20Two%20Time%20Series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796450%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20different%20daily%20frequency%20time%20series%20(crude%20oil%20and%20the%20dollar%20index).%20But%20the%20dates%20don't%20match.%26nbsp%3B%20I%20want%20to%20match%20the%20dates%20for%20them%20so%20I%20can%20plot%20them%20on%20the%20same%20graph.%20Can%20I%20use%20Power%20Query%20Editor%20to%20match%20the%20dates%3F%20I%20want%20to%20use%20all%20the%20dates%20for%20crude%20oil%20and%20just%20back%20fill%20data%20for%20the%20dollar%20index%20if%20they%20are%20missing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20a%20copy%20of%20the%20spreadsheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1796450%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%20Editor%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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