Forum Discussion
Anonymous
3 years agoNot applicable
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...
- 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 __RESULTFile is attached.
Anonymous
3 years agoNot applicable
Fowmy
You understood my question correctly š
I have got now my 2nd table as expected.
Thank you very much for your help!
You understood my question correctly š
I have got now my 2nd table as expected.
Thank you very much for your help!