title: How to look/peek at previous or next rows
body: <p>Hi I'm new to power query and I'm stuck on an issue which i hope you can help - I have an audit report looking a records changing status and i want to be able to use the [Time Stamp] of the next record to calculate the datediff.</p>
  
  <p>In Qlikview, i've used peek() and previous() and SQL, lead() and lag() but is there a function i can use in power query(M)    </p>
  
  <p>ID    [Old Status] [New Status] [Time Stamp] [Duration]
  1        NEW         Estimated     6/1/2015<br>
  2        Estimated    Planned      7/1/2015   </p>