Filter by date and time range

[chjr7777]

We have two work schedules.

Schedule 1: 

Mon 5a until Sat 5a

Schedule 2:

Mon 5a-11:59p
Tues 12a-2a, 5a-11:59p
Wed 12a-2a, 5a-11:59p
Thur 12a-2a, 5a-11:59p
Fri 12a-2a, 5a-11:59p
Sat 12a-2a, 5a-11:59p
Sun 12a-2a

I need to filter all matching data by these date and time ranges.

These could be 2 separate reports.

Data example:

Can I use a DAX filter to accomplish this or do I need to create a calendar table?

[lbendlin]

Not only do you need a calendar table, but you will also need a separate Shifthours table.  For each day of the week and each of the 24 hours you need to indicate if a shift is active in that hour or not.