title: DAX expression for sumarizing values to a set date
body: <p>I have done some tests myself but all has been unsuccessful, but if I am missing something please feel free to ask for more information.</p>
  <p>I have a spreadsheet with contract numbers on the rows and amortizations on the columns, like the following example:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th></th>
  <th>Original Value</th>
  <th>2011</th>
  <th>2012</th>
  <th>2013</th>
  <th>2014</th>
  <th>2105</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1001</td>
  <td>2000</td>
  <td>10</td>
  <td>10</td>
  <td>10</td>
  <td>10</td>
  <td>10</td>
  </tr>
  <tr>
  <td>1002</td>
  <td>1500</td>
  <td>20</td>
  <td>20</td>
  <td>20</td>
  <td>20</td>
  <td>20</td>
  </tr>
  <tr>
  <td>1003</td>
  <td>1200</td>
  <td>0</td>
  <td>0</td>
  <td>15</td>
  <td>15</td>
  <td>15</td>
  </tr>
  <tr>
  <td>1004</td>
  <td>3000</td>
  <td>0</td>
  <td>0</td>
  <td>0</td>
  <td>0</td>
  <td>10</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Using DAX is there a good way to make a calculated value for the present value for each of the time frames? As the example below show:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th></th>
  <th>Original Value</th>
  <th>PV2101</th>
  <th>PV2102</th>
  <th>PV2103</th>
  <th>PV2114</th>
  <th>PV2105</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1001</td>
  <td>2000</td>
  <td>1990</td>
  <td>1980</td>
  <td>1970</td>
  <td>1960</td>
  <td>1950</td>
  </tr>
  <tr>
  <td>1002</td>
  <td>1500</td>
  <td>1480</td>
  <td>1460</td>
  <td>1440</td>
  <td>1420</td>
  <td>1400</td>
  </tr>
  <tr>
  <td>1003</td>
  <td>1200</td>
  <td>0</td>
  <td>0</td>
  <td>1185</td>
  <td>1170</td>
  <td>1155</td>
  </tr>
  <tr>
  <td>1004</td>
  <td>3000</td>
  <td>0</td>
  <td>0</td>
  <td>0</td>
  <td>0</td>
  <td>2990</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>So a calculated value that sums upp all prior amortizations dependant on the date in the x-axis and reduces that amount from the original value.</p>