Earliest Date column split by ID

[M_SBS_6]

Hi, 

I have a table of which I have 3 rows of data.

ID. Name. Date

12. Ian B. 29/03/2023

12. Ian B. 17/12/2018   

12. Ian B. 15/04/2019

13. Kevin A 01/03/2022

13. Kevin A 02/02/2024

What I'd like for those 3 rows is to have another column which just populates the earliest date out of all values for that ID and Name. So I'd like my table to output like below

ID. Name. Date. EarliestDate

12. Ian B. 29/03/2023. 17/12/2018

12. Ian B. 17/12/2018 17/12/2018

12. Ian B. 15/04/2019. 17/12/2018

13. Kevin A 01/03/2022. 01/03/2022

13. Kevin A 02/02/2024. 01/03/2022

[parry2k · Accepted solution]

@M_SBS_6 add new column using following DAX expression:

Earliest Date = 
CALCULATE ( 
    FIRSTDATE ( TestTable[Date] ), 
    ALLEXCEPT ( TestTable, TestTable[Id], TestTable[Name] ) 
)