Filter date-ranges of one table with slicer from range of dates in another table using measures

[Anonymous]

I have a table Staff Booking and Date.

The Date table is created using:

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

How can I filter the 'Staff Booking'[Start Date] and 'Staff Booking'[End Date] using the Date range in a slicer?

This is what I am trying to achieve:
1) The date range in slicer is picked
2) Staff Booking that fall in the slicer range are filtered, using the Staff Booking start/end date
3) The result is further filtered according to the 'Staff Booking'[Booking Type]

I believe it should involve a measure somewhere but I have no idea where to get started with.

The data is being displayed in Gantt chart, the slicer with Date should control what bookings are shown in the gantt chart after the filtering steps described above

[amitchandak]

Try if this can help : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...