Forum Discussion
usman96
Helper II
Helper IIFind the earliest date in a record
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
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.
4 Replies
- Greg_Deckler
Community Champion
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.
usman96what if i have two fields?
Subject A subject B
- petrovnikitamai
Resolver V
try to add column.
new column = minx(filter(table;earlier(date)=date);subject)
- usman96
what if i have two fields?
Subject A subject B
