Good Afternoon,
I’ve made a slice that is capable of showing information only for the user’s chosen date range. I would like to take this one step further and allow them to view the data for only the chosen day of the week within that date range. So for example, only viewing Thursdays from 09/01/20-09/30/20.
This is what I have so far. How would I change this so that it only shows the chosen day of the week?
IN( [Date:], SELECT(Class History[Date:], AND( [Date:]>=ANY(Date Filter[Start Date]), [Date:] <=ANY(Date Filter[End Date]))))
Thank you,
Kat
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |