what is the best expression to choose the most recent data from a column?

Good night noble friends, what is the best expression to choose the most recent data from a column?
This is not giving me the expected result!

I want to select the most current value from the column, based on date and time..

ANY(SELECT(Senha de Acesso ao Cadastro[NovaSenha],
TODAY() <= DATE(
ANY(
TOP(
SORT(
SELECT(Senha de Acesso ao Cadastro[Submission Date], TRUE ),
true
),1
)
))+3
))

_______________

My goal is to make a password obsolete in 3 days.
Example: The password created now, after 3 days it no longer serves.

table.png

 

0 1 105
1 REPLY 1

Pasando para informar que he logrado con esa:
Compartiendo con todos para contribuir un poco con los que necesiten!

Cordial saludo!

ANY( SELECT( Senha de Acesso ao Cadastro[NovaSenha], AND( [Senha_ID] = MAXROW("Senha de Acesso ao Cadastro", "_ROWNUMBER"), TODAY() <= DATE([Submission Date])+3 ) ) )

Top Labels in this Space