Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Jlindsey001
Frequent Visitor

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:

SampleData1Screenshot.png

 

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

1 ACCEPTED SOLUTION

You want to think long and hard before you go for this - it is very klutzy and I don't think the user experience will be meaningful

 

lbendlin_0-1729906274035.png

 

And yes - the week number column is critical. It will not work without it.

 

 

 

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

What if the user chooses from Tuesday to Tuesday ?

lbendlin_0-1729904459839.png

See attached for a data reduction approach.

Thanks @lbendlin ... the output would still follow the parameters: I.e. open price 7/9 to close price 7/16, next row open price 7/16 to close 7/23, etc. 

 

Assuming that is possible, otherwise we will not be able to do week day to same week day.

You want to think long and hard before you go for this - it is very klutzy and I don't think the user experience will be meaningful

 

lbendlin_0-1729906274035.png

 

And yes - the week number column is critical. It will not work without it.

 

 

 

Thank you! I've given this a test run and I agree it's a bit wonky but it will accomplish what I am trying to solve. I really appreciate the guidance on this, it's helped a ton.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.