cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
serargi Frequent Visitor
Frequent Visitor

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moderator v-sihou-msft
Moderator

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

@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,

 

View solution in original post

3 REPLIES 3
Highlighted
Moderator v-sihou-msft
Moderator

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

@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,

 

View solution in original post

Areg New Member
New Member

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

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

Anth79 Frequent Visitor
Frequent Visitor

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Kudoed Authors (Last 30 Days)