1 of 1 people found this helpful
I think we can accomplish this type of filtering using an LOD calculation. I started by making a calc, [Max Date per Name], to find the maximum date for each person:
We can see that for the Names with multiple rows, the Max Date value is replicated for each row.
Next we need to create a boolean comparison that checks whether the [Date] value for any row is equal to the Max date value:
And lastly, we'll just filter on this calc and set the filter to only show True values:
Hope this helps!