topic Re: Column to return earliest date based on another column in DAX Commands and Tips

Column to return earliest date based on another column

Topjacket — Thu, 09 Feb 2023 18:29:17 GMT

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

Re: Column to return earliest date based on another column

tamerj1 — Thu, 09 Feb 2023 18:39:40 GMT

Hi Topjacket

create a new calculated column:

Earliest Date =
MINX (

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

'Table'[Case Month and Year]

)

Re: Column to return earliest date based on another column

Topjacket — Thu, 09 Feb 2023 20:37:07 GMT

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