topic Re: Dates table outside slicer selection in DAX Commands and Tips

Dates table outside slicer selection

Anonymous — Sun, 05 Mar 2023 10:11:02 GMT

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!

Re: Dates table outside slicer selection

Fowmy — Sun, 05 Mar 2023 12:52:53 GMT

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.

Re: Dates table outside slicer selection

Anonymous — Sun, 05 Mar 2023 16:01:11 GMT

Fowmy
You understood my question correctly 🙂

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