Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Getting values for unique ID's after sorting DESCENDING Data

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

Data Protection

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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