Date and Time filter for "x" hours from now

[dude95]

Relatively new user here - trying to get concepts down.

I have a table of tasks (basically from MS Project).  There is a start date field (date format) and a start time field (time format).  I need to filter for tasks that will start in the next x amount of time.  There is also a status field - and I don't want to pick up status of 0 (completed) tasks.  I'm using a parameter to record the amount of time - which may vary depending on where we are in the project plan.

Once I have tasks that are in the next 4 hours, I need to go to a resources table to pull out resources associated with those tasks (I have a many to 1 relationship set up with the resources table.)

All of my knowledge of Power BI comes from this forum and Google - so I'm not sure where to start on this.  Is it a new DAX measure in the table to filter on?  Do I change my query and add a column?  There are other visualizations on the report that I don't want this filter to be a part of, but I'm a little unsure how I filter the resources table based off of the tasks table without impacting everything else???

Appreciate any help out there.  Let me know if I need to supply more info.

Thanks!

[Greg_Deckler · Accepted solution]

I believe my TIMEADD Quick Measure might help you create the filter you need.

https://community.powerbi.com/t5/Quick-Measures-Gallery/TIMEADD/m-p/585280?search-action-id=87488641...

[dude95]

Wow - in less than an hour you answered my question perfectly and your link even has a downloadable example!!  Thanks so much!!!