I need to find the most recent date in a grouping sorted by another metric. Is there a formula to find the most recent date? I was trying FIRST, but because the base columns are not sorted by this date field, I’m not sure if it’s giving me the date on top or the most recent one.
Using the aggregate
Max will get you the most recent date.
Min will get you the earliest date.