Custom Sort Order - First/Last not working as expected (erroneously ignores custom sort order)

[camelCase]

I have a formatted date column (Date_ddd_dd_hh = FORMAT('mydata'[DateStarted], "dd/mm, ddd HH:00 yyyy"))

custom sorted on (Date_ddd_dd_hh_sort = FORMAT('mydata'[DateStarted], "yyyy-mm-dd HH"))

When using First or Last the custom sort is erroneously ignored - is there a way to display the correct first/last date in the custom formatting (ie. showing first/last dates in a format not specified in the default date format list)

Correct custom sort in table.	INCORRECT when specifying FIRST	INCORRECT when specifying LAST

[amitchandak · Accepted solution]

@camelCase , You might have to create a measure like

measure =
Var _min = minx(allselected(Table), Table[custom sorted])
return
maxx(filter( Table, Table[custom sorted] =_min),Table[formatted date])