Forum Discussion
DAX Filter Table By Weekday Slicers - Two Date Columns
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
And yes - the week number column is critical. It will not work without it.
What if the user chooses from Tuesday to Tuesday ?
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
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.
