Set customer registration date

[Syndicate_Admin]

Hello

I have the following table (this is just an excerpt):

The "DateLastActivity" date shows when the client record was modified and may be duplicated multiple times (as seen).

I would like to create the "Customer Registration Date" column of a customer with an ID that was equal to the first date on which that customer ID appears and is applied to all rows of that customer. how could I do it?

Thank you very much and greetings

[v-eqin-msft]

Hi @Syndicate_Admin ,

Any updates?

Best Regards,
Eyelyn Qin

[v-eqin-msft · Accepted solution]

Hi @Syndicate_Admin ,

I did not see the "# Trello Card" as well.😂 Maybe you mean the second column...

Please simplty use:

Column = CALCULATE(MIN('Table'[DateLastActivity]),ALLEXCEPT('Table','Table'[Trello Card]))

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , Not able to see ID column in sample data

You can create a new column like for Min date

minx(filter(Table, [ID] =earlier([ID]) ) , [DateLastActivity])

[Syndicate_Admin]

Sorry, I haven't explained myself well. The customer ID is "# Trello Card". The table is of modifications to the customer's records and the first recorded activity is when the customer was registered.