title: How to get the previous day value as a measure
body: <p><strong>Situation:</strong></p>
  
  <p>I currently have two columns (date, value). I would like to create a measure calculating the previous day value.</p>
  
  <p><strong>Sample values:</strong></p>
  
  <pre><code>date    Column1
  1/1/2019 0:00   10
  1/2/2019 0:00   20
  1/3/2019 0:00   30
  1/4/2019 0:00   50
  1/5/2019 0:00   100
  1/6/2019 0:00   20
  1/7/2019 0:00   30
  1/8/2019 0:00   40
  </code></pre>
  
  <p><strong>Sample Output:</strong></p>
  
  <pre><code>+---------------+---------+---------------+
  |     date      | Column1 | previousvalue |
  +---------------+---------+---------------+
  | 1/1/2019 0:00 |      10 |               |
  | 1/2/2019 0:00 |      20 |            10 |
  | 1/3/2019 0:00 |      30 |            20 |
  | 1/4/2019 0:00 |      50 |            30 |
  | 1/5/2019 0:00 |     100 |            50 |
  | 1/6/2019 0:00 |      20 |           100 |
  | 1/7/2019 0:00 |      30 |            20 |
  | 1/8/2019 0:00 |      40 |            30 |
  +---------------+---------+---------------+
  </code></pre>