title: PowerBI filter- selected Date between Start and End date
body: <p>I'm building a PowerBI report from a dataset that contains start and end dates. I'd like to filter the dataset based on rows that would encompass a selected date in another table.</p>
  
  <p>The screenshot here shows a sample. I want to click a date in the table on the right and have the table on the left filtered where the selected date is between the start &amp; end date.</p>
  
  <p><a href="https://i.stack.imgur.com/6CYcn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6CYcn.png" alt="Two datasets side-by-side. One has a Start and End date. The other is a list of dates."></a></p>
  
  <p>I've attempted several different things using columns and measures, but I haven't been able to nail it down. I also attempted to create a new table from a DAX expression that references the selected date, but that caused errors.</p>
  
  <p>How can I dynamically filter the dataset based on the selected date being between the start and end date values?</p>