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.

Shahid12523's avatar
Shahid12523
Community Champion
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.

dainova's avatar
dainova
Regular Visitor
1 year ago

Thanks Shahed !!!
I realized I made an error in my post, need rows where date older then 7 days from now, but I got an idea now, I know how measure works, strange it can not use it in the filter box.

But I need to solve another problem on the way, I can not add new column, in data view I have this message, I work with Dataverse source, need to check what is going on.

 




Best
D