Forum Discussion
Solved
Min date return other value
I would like to return the "Seq. #" that has the oldest "Date Open" ould like to return the "Seq.#" with the oldest "Open Date"
mhankila ,
Firstnonblankvalue(Table[date Open], Min([# Seq])
or
calculate(Firstnonblankvalue(Table[date Open], Min([# Seq]) , allselected())
mhankila ,
Firstnonblankvalue(Table[date Open], Min([# Seq])
or
calculate(Firstnonblankvalue(Table[date Open], Min([# Seq]) , allselected())