Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a column of names and a column of dates and times, I want to show the first instance of each name in the data set against the earliest date/time.
I have a filter pane that allows me to select a date but I need a filtering expression I believe to set my updatedBy and updatedON columns to only show the first instance of each
Could you please post some sample data and with expected output .
I've attached an excel document, data on the left and expected output on the right.
I have names repeating but I only need the first instance of the name and the time associated with it.
Sounds like you're looking for either Min()/Max() or for FirstSortedValue(), but it's hard to say exactly without understanding the specifics.