Getting values for unique ID's after sorting DESCENDING Data

[Anonymous]

I have a monthly database, I want to get the value of the first contract for a unique ID at the first date that this ID appears in the database

[amitchandak]

@Anonymous , You can put ID and Date in visual (Table) and sort the visual on Date Descending

[Anonymous]

I want to create a column that says which was the first contract for this unique ID.