title: Power BI Desktop - Counting Items in a bucket over a date range
body: <p>I need to count commodity movements over a date range. </p>
  
  <p>Details:
  Rail car A contains Commodity Corn. It is loaded on 11/1/2018 and is unloaded 11/3/2018.</p>
  
  <p>I have a custom date table(don't know if I need this) that shows an entry for each day, whether there is data or not. </p>
  
  <p>In my dataset, I have a row of data that expresses the LoadNumber, Commodity, Load Date, and Unload Date. </p>
  
  <p>I have this working in as much that the graph is showing each commodities start date.</p>
  
  <p>I need to show on a graph that there was one load of Corn on the rails from 11/1/2018 to 11/3/2018. If there are multiple loads during that time frame, then the graph should reflect that by adding the value to the relevant dates commodity bar. We are currently using excel to populate the Data, but will eventually switch to query, if that makes any difference.(I want to rely on as little excel magic as possible)</p>
  
  <p><a href="https://i.stack.imgur.com/a6M6z.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/a6M6z.jpg" alt="Chart Example"></a></p>