Column to return earliest date based on another column

[Topjacket]

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 · Accepted solution]

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

[tamerj1]

Hi @Topjacket 

create a new calculated column:

Earliest Date =
MINX (

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

'Table'[Case Month and Year] 

)