Forum Discussion
Solved
How add dynamic filter value (for date )
Hi, How I can implement my filter for date 7 days from now in my filter like in example below. I've created Last7Days measure but can not move into the filter box, tried all types of filtering. ...
You can’t put a measure in the filter pane.
Use one of these:Relative date filtering on your Modified On column → set to last 7 days.
Or create a column:
IsLast7Days =
IF('Table'[Modified On] >= TODAY()-7 && 'Table'[Modified On] <= TODAY(), 1, 0)
Then filter IsLast7Days = 1.
Hi dainova
You can create flag column in the calculated table, with the formula like:
Last 7 days flag = if('Calendar'[Date]>= TODAY()-7 && 'Calendar'[Date]< TODAY(),1,0)
This column can be used as a filter in all the levels ( visual / page/ all pages)
This column can be used as a filter in all the levels ( visual / page/ all pages)
The pbix with the example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks so much Rita !