DAX Filter Table By Weekday Slicers - Two Date Columns

Hey all,

Sample data: SampleData1.xlsx

I have a main table with columns for DateTime by the minute, an open price, a close price, a high price and a low price. I have added a week day and number column as well. I also have a DateTable with week day info (day, day number, week number, etc).

My requirements are to create an output / visual table that shows a table:

•  With a week start column and week end date column by weekday. The weekdays are filtered by two slicers, one for week start and one for week end. So we could have a week start Monday and end Friday, but could also look at week start Tuesday and end Thursday. We also need to account for wrap around weeks, so a week start on Friday and end the following Monday.
• And with a slicer for Open to Open, Open to Close, and Close to Open based on the earliest open price and latest close price for the given dates. So for example, the Open to Close selection would show the week start date open price and the week end date close price.

Example below:

My first thoughts were to create separate date tables to filter each the start and end of the week and create measures from those. However I run into an issue when applying the filters to the table visual, I get a blank result. It seems I am having trouble filtering individually the week start and week end and having them populate appropriately in the table visual.

Thanks everyone