Forum Discussion
Dates table outside slicer selection
Hello everyone.
Probably simple solution but I'm struggling with getting dates outside slicer selection.
I've got one table showing slicer's dates, but I need another one with extended dates.
For instatnce:
I've one week chooosen from slicer.
In the 2nd table I need to display week before, selected week and next week dates.
How should I deal with that?
Thank you in advance!
Anonymous
If I understood your question correctly, you need to have an additional dates table to have the desired result. Create a measure to filter the Extended table Viz as follows:ExtendedDateFiter = VAR __DATEMIN = MIN('Dates'[Date]) VAR __DATEMAX = MAX('Dates'[Date]) VAR __DATEEXT = SELECTEDVALUE('Dates Extended'[Date]) VAR __RESULT = INT( __DATEEXT >= __DATEMIN - 7 && __DATEEXT <= __DATEMAX + 7 ) RETURN __RESULTFile is attached.
2 Replies
- Fowmy
You understood my question correctly 🙂
I have got now my 2nd table as expected.
Thank you very much for your help! - Fowmy
Super User
Anonymous
If I understood your question correctly, you need to have an additional dates table to have the desired result. Create a measure to filter the Extended table Viz as follows:ExtendedDateFiter = VAR __DATEMIN = MIN('Dates'[Date]) VAR __DATEMAX = MAX('Dates'[Date]) VAR __DATEEXT = SELECTEDVALUE('Dates Extended'[Date]) VAR __RESULT = INT( __DATEEXT >= __DATEMIN - 7 && __DATEEXT <= __DATEMAX + 7 ) RETURN __RESULTFile is attached.