Table relationship to ensure table filters with the date slicer when the dates in table overlap

[Anonymous]

I have a table `Staff Booking` containing `Start date` and `End Date` for a job. I also have a calculated table filed with

Date Range 2 = CALENDAR(MIN('Staff Booking'[Start Date]), MAX('Staff Booking'[End Date]))

I want to eventually make a relationship between these two table such that:

1) When the date slicer range is defined, the jobs that overlap the slicer are filtered (using the start dat and end date columns)

2) And for the jobs that overlap, if the `start date < min(slicer date)` then `start date` change to `min(slicer date)`

[amitchandak]

@Anonymous 

Refer if this can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970