title: How to use aggregation in filters in Power BI using DAX
body: <p>Below are the samples of 2 datasets that I am working with.</p>
  <p><a href="https://i.stack.imgur.com/rGfEs.png" rel="nofollow noreferrer">Stock information of items</a>
  <a href="https://i.stack.imgur.com/RmM5v.png" rel="nofollow noreferrer">Forecast of those items</a></p>
  <p>Now, I am trying to calculate the month from the second picture which exceeds the stock in the first picture.</p>
  <p>Could you please help me with how to calculate the month when the forecast exceeds stock from the time of &quot;Date&quot; column in picture 1?</p>
  <p>Let me know if you require any further explanation or information.</p>
  <p>Thanks in advance,
  Vijay</p>