title: DAX: Reset a cumulative total by certain date thresholds
body: <p>I have a cumulative total of CE's <code>CE's cumulative</code> (see below).</p>
  <p>I need the cumulative total to reset to 0 after hitting the <code>ResetDate</code></p>
  <p>Looked all around forums but unable to find the answer, hope you can help me out.</p>
  <pre><code>CE's cumulative =
  CALCULATE(
     SUM (CE's),
       FILTER( ALL( DimDate),
       DimDate[Date] &lt;= MAX( DimDate[Date] )
             )
           )
  
  </code></pre>
  <pre><code>Date    CE's cumulative ResetDate
  10-10-2019  77.670.099  
  11-10-2019  78.057.691  11-10-2019
  12-10-2019  78.114.554  
  13-10-2019  78.234.181  
  14-10-2019  78.469.789  
  15-10-2019  78.709.015  15-10-2019
  16-10-2019  80.070.020  
  </code></pre>