Forum Discussion

dainova's avatar
dainova
Regular Visitor
1 year ago
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. ...
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    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.

Ritaf1983's avatar
Ritaf1983
Super User
1 year ago

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)

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

  • KarinSzilagyi's avatar
    KarinSzilagyi
    Super User
    1 year ago

    Please correct me if I'm wrong, but I was taught to avoid calculated columns, especially for simple cases like this where it would only affect a few entries, since they bloat the model.

    They're also only refreshed on load, so if the Semantic Model isn't refreshed daily, this would give wrong results since the evaluated today() would always point to the last refresh date. 

    Due to those points I personally would use a filter-measure with the same logic instead, but please feel free to correct me if I'm wrong.

  • dainova's avatar
    dainova
    Regular Visitor
    1 year ago

    Thanks so much Rita !