Filtering "older than" data

Question

I have a table of inspections.&nbsp; It is summarized&nbsp; to only display the "Latest" inspection date at each Site.&nbsp;&nbsp;I want to filter the table so that I only see the latest inspection if it is greater than 14 days old.&nbsp; The visual filter only gives me specific date options, not relative.&nbsp; I have been playing with the FILTER expression in DAX but I'm not getting anywhere.

gadielsolis · Accepted Answer

Hello,&nbsp;If I'm not mistaken Inspection is a field within the table so you'll need to have this as a measure.&nbsp;You can use LastInspection=Max(Inspection)Then to show only if is greater than 14 days you can use the following measureLastInspection2=If(INT(Today()-LastInspection)&gt;14,LastInspection)&nbsp;Hope this helps&nbsp;&nbsp;

Forum Discussion

Filtering "older than" data

2 Replies

Related content

Bulk "Replace" Multiple columns in Power Query that has date older than certain value

Custom column to return "Expired" value if date within a different column is older than six months

"More than" "Less than" text logic in filter

Filter

Visual level filter with "greater than or equal to"