title: Date Filtering for Active rows based on begin and end date
body: <p>Good Afternoon,</p>
  <p>For a project I need a method to show with a year filter which rows were active in that year based on a start and an end date.</p>
  <p>Example dates:</p>
  <ol>
  <li>25th Oct 2019 - 14th Jul 2022</li>
  <li>1st Feb 2020 - 1st Jan 2022</li>
  <li>25th May 2016 - 24th May 2018</li>
  </ol>
  <p>With A filter on 2020 this would mean:</p>
  <ol>
  <li>Show</li>
  <li>Show</li>
  <li>Don't show</li>
  </ol>
  <p>I have an approach that works but it only works if you enter a specific date as a filter. My measure works like this:
  I have a separate datetable that I use as a filter, this value is stored in the variable selDate, and the isActive variable checks whether this variable date falls in between.</p>
  <p>My DAX code:
  Find_active_row =
  var selDate = SELECTEDVALUE(Dates[Date])
  var isActive if(and(selDate&gt;=firstdate(Table[Startdate]),selDate&lt;=firstdate(Table[enddate])),1,0)
  return isActive</p>
  <p>So my problem is I want to filter by year and now I need to filter a specific day for it to work. I'm actually looking for a replacement for firstdate because this doesn't work if I make Table[Startdate].year because it won't be a date field anymore. I hope my problem is clear and any help is appreciated :)</p>