Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
1 year ago
Solved

Earliest Date column split by ID

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

Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    M_SBS_6 add new column using following DAX expression:

     

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

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    1 year ago

    M_SBS_6 add new column using following DAX expression:

     

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