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   Wha...
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] ) 
)
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] ) 
)