Find the earliest date in a record

[usman96]

I have 2 columns 

I need to pick the subjects from unique dates when it appears

so for exampel , from above data , A should be picked

[petrovnikitamai]

try to add column.

new column  = minx(filter(table;earlier(date)=date);subject)

[usman96]

what if i have two fields? 
Subject A subject B

[Greg_Deckler · Accepted solution]

Seems like you could just use MIN([Subject]), if you put your date field in a table and that measure, should do the trick I think, if I understand what you are going for.

[usman96]

what if i have two fields? 
Subject A subject B