title: Cumulative/Rolling Sum Blank Dates
body: <p>I'm currently working on inventory reconciliation, and I've struggling to fill all days of the calendar with the cumulative sum of product we're currently storing: </p>
  
  <p><a href="https://i.stack.imgur.com/D0bmq.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D0bmq.jpg" alt="enter image description here"></a></p>
  
  <p><code>Inventory level ($). = CALCULATE(SUM(ledger[cost]),FILTER(ALL(DimDate[Date]),DimDate[Date]&lt;=MAX(ledger[Document Date])))</code></p>
  
  <p>As you guys might notice it has at least 90% of all dates filled, however if we look closely to the graph, we can appreaciate March 5th of 2016 is missing just due to the fact there was no transaction during that day resulting on a blank value. However I'm trying to accomplish retrieving the previous day balance for those days with no transactions. e.g: for March 5th should have $17,038,462.32 (balance for the previous day March 4th).</p>
  
  <p>I'm trying to work on another clause into the measure with functions such as EARLIER or LASTDATE, however I haven't been succesful.</p>
  
  <p>Any insight or solutions works well thank you. Have a nice day.</p>