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 c...
  • 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])
     
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])