Dates table outside slicer selection

[Anonymous]

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?

VAR _CurrentStartDate = MIN('Calendar'[Date])

VAR _CurrentEndDate = MAX('Calendar'[Date])

VAR _period = DATEDIFF(_CurrentStartDate, _CurrentEndDate,DAY) + 1
Thank you in advance!

[Anonymous]

@Fowmy 
You understood my question correctly 🙂

I have got now my 2nd table as expected.
Thank you very much for your help!

[Fowmy · Accepted solution]

@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
    __RESULT

File is attached.