title: DAX to determine quantity of a product in stock for Power BI
body: <p>In Power BI I'm looking to graph the stock of a product over time.  I in essence only have one product, and the table that's stored in has a line for each instance of that item.</p>
  
  <p>An abbreviated example of that table is:
  ID
  Volume
  DateIn
  DateOut</p>
  
  <p>I'm trying to figure out the best approach of graphing the daily stock of this.  I have a date table that's related to DateIn (which I'm unsure of).  I've tried creating a measure to determine if the row is in stock, given the filter context.  </p>
  
  <p>I'm debating if this needs to be a separate table, used only for stock.  So in essence the table would be:</p>
  
  <p>ID
  Volume
  InStockOnDate</p>
  
  <p>Does anyone have some guidance?  I've been spinning on this on the back-burner for a while now.  </p>
  
  <p>Cheers</p>