Earliest Date of dimensions selected

[JustinM]

Hi

I have the following type of data:

ID	Event Date
A	15/06/2021
A	11/03/2022
A	10/04/2022
B	11/03/2022
B	15/03/2022
C	10/01/2022
C	20/02/2022
C	15/03/2022
C	22/05/2022

I would like to create a formula that calculates the earliest date of event for each ID. Something like this:

ID	Event Date	Earliest Date
A	15/06/2021	15/06/2021
A	11/03/2022	15/06/2021
A	10/04/2022	15/06/2021
B	11/03/2022	11/03/2022
B	15/03/2022	11/03/2022
C	10/01/2022	10/01/2022
C	20/02/2022	10/01/2022
C	15/03/2022	10/01/2022
C	22/05/2022	10/01/2022

Any help would be much appreciated

[Or]

Load ID, date(min([Event Date])) as [Earliest Date]

From Table1

Group by ID;

JOIN

Load ID, [Event Date]

From Table2;