Forum Discussion
Set customer registration date
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
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.
4 Replies
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])
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.
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.
