Forum Discussion

Topjacket's avatar
Topjacket
Icon for Helper I rankHelper I
3 years ago
Solved

Column to return earliest date based on another column

Hi

 

I have a column "Case Month and Year" which lists the date of a case, I then have another column "Version Code". I would like a column that will will return the earliest date for the Version code in each row of data.

 

I have tried adding a new table with a distinct list of version codes but no matter which way I try I am just getting the earliest date of the entire dataset, not the earliest date spesific to the Version code.

 

I hope this is something easy! Any help would be great,

 

Thanks 

 

 

  • Topjacket's avatar
    Topjacket
    3 years ago

    Hi Tamerj1

     

    Thanks very much for the super quick reply. I think I must have entered something wrong but this was also returning the earliest overall date for each record rather than the version code earliest date.

     

    I have ended up creating a new table of distinct versions and then applied the following DAX which seems to be working

     

    Earliest Record = MaxX( FILTER('Table',[Version Code] = EARLIER('Table'[Version Code])),'Table'[CaseMonthAndYear])
     

2 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Topjacket 

    create a new calculated column:

    Earliest Date =
    MINX (

    CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Version Code] ) ),

    'Table'[Case Month and Year] 

    )

  • Topjacket's avatar
    Topjacket
    Icon for Helper I rankHelper I
    3 years ago

    Hi Tamerj1

     

    Thanks very much for the super quick reply. I think I must have entered something wrong but this was also returning the earliest overall date for each record rather than the version code earliest date.

     

    I have ended up creating a new table of distinct versions and then applied the following DAX which seems to be working

     

    Earliest Record = MaxX( FILTER('Table',[Version Code] = EARLIER('Table'[Version Code])),'Table'[CaseMonthAndYear])