title: PowerQuery Fill missing dates and data
body: <p>How can you get PowerQuery to: </p>
  
  <ol>
  <li><p>Generate the missing dates </p></li>
  <li><p>Fill the missing dates with the previous most recent values</p></li>
  </ol>
  
  <p>Desired input and output are outlined below:</p>
  
  <p><strong>Input</strong></p>
  
  <pre><code>+------------+------+-------+
  |DATE        | CUR  | RATE  |
  +------------+------+-------+
  | 01-01-2019 | EUR  | 0.7   |
  | 01-01-2019 | USD  | 0.8   |
  | 03-01-2019 | EUR  | 0.71  |
  | 03-01-2019 | USD  | 0.81  |
  </code></pre>
  
  <p><strong>Output</strong></p>
  
  <pre><code>+------------+------+-------+
  |DATE        | CUR  | RATE  |
  +------------+------+-------+
  | 01-01-2019 | EUR  | 0.7   |
  | 01-01-2019 | USD  | 0.8   |
  | 02-01-2019 | EUR  | 0.7   |
  | 02-01-2019 | USD  | 0.8   |
  | 03-01-2019 | EUR  | 0.71  |
  | 03-01-2019 | USD  | 0.81  |
  </code></pre>