How can I do relative filtering "is not in the last 7 days"?

[serargi]

Hello,

I am using a table and I need to do some filtering. Is it possible to do "is not in the last" filtering? By default in relative data filtering you have

- is in the last

-in this

- in the next

But I need to be aware when a row is not update from the last 7 days, it has timestamp in the colum "LastUpdated".

Regards!

[JMacC]

If oyu can't edit the source data to filter out/add a column, I've added a calculated column which uses DateAdd(DateCol, no.days, Day) which I then filter relatively. 

So if I wanted not past 7 days: 

AdjDate = DateAdd(MyDateCol, 7, Day)

then relative filter page/element on AdjDate in past 10000 days. 

Because it's ahead of the actual date by 7, the report will then exclude dates who's +7days is in the future. Hacky but it works

[Anth79]

Vote this up:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37539733-expand-relative-date-fil...

[Areg]

1.5 years later, the ability to exclude current time period is still not available 😞

[v-sihou-msft · Accepted solution]

@serargi

Currently, there's no "is not in the last X days" filter in relative date filter. You may submit a feature request on idea.

To workaround this, you can create a calculated column to tag if current row date is within Last 7 days. Then put this field into Visual Level Filter.

IsWithin7Days=IF(Table[Date]>TODAY() && Table[Date]<TODAY()-7,1,0)

Regards,