DAX to get column value corresponding to first non blank date

[Anonymous]

Hi Community,

Following is my sample dataset. 'Firstnonblank Servicedate' is a calculated column that gets the first or the earliest date. I would like to know how can I create a calculated column 'Service Type of Firstnonblank Servicedate'?

Thanks in advance!

[Anonymous]

@Anonymous You can try like below - 

NewColumn = IF(ISBLANK('Table'[Firstnonblank Servicedate]),BLANK(),'Table'[Service_Type])

[Anonymous]

@Anonymous  sorry it doesn't work. It reurns all the service types.

[amitchandak · Accepted solution]

@Anonymous , Try new column like

minx(filter(Table, Table[Service Date] = earlier([Firstnonblank Servicedate])),[Service Type])
or
minx(filter(Table, Table[Service Date] = earlier([Firstnonblank Servicedate])),earlier([Service Type]))