DAX Query - Filtering by latest date/time with Direct Query Dataset

Hi,

Although it would be helpful to have a sample pbix a general response. You can find many solutions for events happening between times, such as HR related and Patients in hospitals. BrianJ did a nice one recently on HR, link to the topic on the forum, Create new dynamic table using selected value from slicer - #5 by BrianJ
Paul