Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
@cienkibp
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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@cienkibp
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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |