Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
It looks like that works! Thank you so much.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |