title: Fill or interpolate missing dates in a matrix in PowerBI
body: <p>Colleagues in my organisation track serviceability of their assets on a daily basis so our bosses can get an idea of what they have to use and how much of an umbrella they need to put up for any day.</p>
  <p>My colleagues use a matrix <a href="https://i.stack.imgur.com/T2DnK.png" rel="nofollow noreferrer">(example of the matrix)</a>, for ease they have the top row as the first date of the week they started on, the second row (not shown) is the day name they're on.</p>
  <p>In PowerBI its easy enough to transpose, and be left with a <a href="https://i.stack.imgur.com/JuaMi.png" rel="nofollow noreferrer">column of dates with blanks</a>. Filling the missing dates is proving difficult.</p>
  <p>I've been able to make little isolated lists of dates but I haven't been able to join them back to the original information.</p>
  <p>Excel can interpolate these, but PowerBI just wants to copy down the value from above.
  Additional caveat; I am restricted in not being able to use Python or R for now.</p>
  <p>Here's another example of the table after I've transposed it to carry out the filling I want to do:</p>
  <pre>
  <b>Column1                       Column2    Column3  Column4 Column5</b>
  null                         Truck      Truck    Car     Car
  null                         Fred       Tim      Alice   Beatie
  Week beginning 8th Aug 2019  Good       Bad      Good    Good
  null                         Bad        Bad      Good    Good
  null                         Bad        Good     Good    Bad
  null                         Good       Good     Good    Bad
  null                         Good       Good     Bad     Bad
  null                         Good       Bad      Bad     Good
  null                         Bad        Good     Bad     Good
  Week beginning 15th Aug 2019 Bad        Bad      Good    Bad
  ...                          ...        ...      ...     ...
  </pre>
  <p>What I would like to end up with is:</p>
  <pre>
  <b>Column1       Column2    Column3  Column4 Column5</b>
  null         Truck      Truck    Car     Car
  null         Fred       Tim      Alice   Beatie
  8/Aug/2019   Good       Bad      Good    Good
  9/Aug/2019   Bad        Bad      Good    Good
  10/Aug/2019  Bad        Good     Good    Bad
  11/Aug/2019  Good       Good     Good    Bad
  12/Aug/2019  Good       Good     Bad     Bad
  13/Aug/2019  Good       Bad      Bad     Good
  14/Aug/2019  Bad        Good     Bad     Good
  15/Aug/2019  Bad        Bad      Good    Bad
  ...          ...        ...      ...     ...
  </pre>
  <p>Thanks in advance!</p>