Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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. Fo...
  • Fowmy's avatar
    Fowmy
    3 years ago

    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.

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
3 years ago

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.