Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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,
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
1.5 years later, the ability to exclude current time period is still not available 😞
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.