title: Find rows relative to current row's value in excel (DAX)
body: <p>Is there a way to filter rows based on your current row's value using DAX (I'm using power pivot) ?</p>
  
  <p>In other words, If I had a table "progress" with 'ID' that is incremented in each row, and a 'Percentage' columns and another table containing </p>
  
  <p>I want to create a column called old percentage = percentage of (progress[ID] -1)</p>
  
  <p>Is this possible in excel ?</p>
  
  <p>I couldn't find any straightforward command in this, and excuse me if there were, I am still new to power pivot.</p>
  
  <p>My way of doing it is perhaps to create a new column old ID = progress[ID] -1 then create a new table in power pivot which is a duplicate of the current table but then I link it with Old ID instead of the current ID.
  Then in the end I do a old percentage column = RELATED([percentage]);</p>
  
  <p>Is this a valid approach towards the problem ? And can this be further optimized ?</p>
  
  <p>Thank you.</p>
  
  <p>EDIT: I've added an image to help display what I need</p>
  
  <p><img src="https://i.stack.imgur.com/FnlQV.png" alt="Calculate Percentage Increase">)</p>