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.

Mauro89's avatar
Mauro89
Super User
1 year ago

Hi dainova,

 

if I understand your request correctly, there is a perfect match for this in PBI. 
In the screenshot you shared from the drop down there is the option "Relative date". Select this, then choose your granularity (in your case days) and type in 7. Additionally you can choose if you want to include the current day or not. 

I hope this fits your purpose?

If yes feel free to mark the post as solution. 

Best regards!

  • dainova's avatar
    dainova
    Regular Visitor
    1 year ago

    Thanks Mauro and all,

    Sorry I realized I made an error in my question,  I need rows where dates older then  7 days from now, but  I got how to do it now.  

    Relative filter doesn't have optiont NOT, which I need, so  I can not use, I need dates which are  NOT in the last 7 days. I learned that this feature is requested from MS but not implemented yet.
    So I think I need go with extra calculated column,

     

    Thanks to all for big help.