Filtering "older than" data

[entomophile]

I have a table of inspections.  It is summarized  to only display the "Latest" inspection date at each Site.

I want to filter the table so that I only see the latest inspection if it is greater than 14 days old.  The visual filter only gives me specific date options, not relative.  I have been playing with the FILTER expression in DAX but I'm not getting anywhere.

[gadielsolis · Accepted solution]

Hello,

If I'm not mistaken Inspection is a field within the table so you'll need to have this as a measure.

You can use LastInspection=Max(Inspection)

Then to show only if is greater than 14 days you can use the following measure

LastInspection2=If(INT(Today()-LastInspection)>14,LastInspection)

Hope this helps

[entomophile]

It looks like that works!  Thank you so much.