Forum Discussion
Filtering for data 2 weeks prior the current date
Hi Anonymous ,
First you need two separate tables, a date table and a fact table. They are not related to each other.
Then create a measure, like the following.
Measure = VAR _selected = MAX ( Slicer[Date] ) VAR _start = _selected - 14 RETURN IF ( SELECTEDVALUE ( 'Table'[Date] ) >= _start && SELECTEDVALUE ( 'Table'[Date] ) <= _selected, 1 )Then put the measure in filter pane and set it show items which is 1.
The output:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous ,
First you need two separate tables, a date table and a fact table. They are not related to each other.
Then create a measure, like the following.
Measure =
VAR _selected =
MAX ( Slicer[Date] )
VAR _start = _selected - 14
RETURN
IF (
SELECTEDVALUE ( 'Table'[Date] ) >= _start
&& SELECTEDVALUE ( 'Table'[Date] ) <= _selected,
1
)
Then put the measure in filter pane and set it show items which is 1.
The output:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much for a quick response!
I have been working through this. Is the slicer what effects the date? I have completed all the steps you have shown and the date is not effected by the DAX formula.
- v-chenwuz-msft
Hi Anonymous ,
Works fine with my pbix.
1 Ensure that the two tables have no relationship
2 measure is placed in the filter pane of the date table visualBest Regards
Community Support Team _ chenwu zhu