If dates one table are between 2 dates on another table return other table related value.

[Necron35]

Hi this is my first time posting and im stumbling through my first Power BI project and have run into an issue im not sure how to tackle.

I have two tables, one with delay data with delay start and end times and another table with crew data with crew start and end times.

I want to add the crew data to the delay table based on if the delay start date falls between the crew start and stop date.

All dates are in Time/Date format with 7am and 7pm being the start and stop of shifts.

Crew Table

Delay Table

 Thank you.

[amitchandak]

@Necron35 , I case you need additional column

maxx(filter(delay, (delay[Start] >= Crew[Start] && Delay[Start] <= Crew[End]) || (delay[End] >= Crew[Start] && Delay[End] <= Crew[End])), [Heat Id])

You can use count too

[Necron35]

@amitchandak 

It might be my lack of experience but i cant get the DAX you suggested to work for two different tables.

Is there something i need to do make that happen?