Referring previous row

[NIPUNAEKA89]

Hi,

I need to show a text to the person who logged in 1st of each day. My logic is "last row's date is not equal to current row's date"

[_THISROW].[_ROWNUMBER]-1 <> Today()

But this doesn't work. Please help

[dbaum · Accepted solution]

Your expression compares a row number to today's date. You need to use a function like SELECT or MAXROW to return the date from the row with the highest row number that is lower than the current row's row number, and then compare that date to today's date.

[NIPUNAEKA89]

I used the following expression with Showif and it worked 

=DATE(MAXROW("Day lead", "_RowNumber", TRUE))<>today()

[TeeSee1]

USEREMAIL()
=
LOOKUP(
 MINROW("your table", "_RowNumber", [logon date] = TODAY()),
 "your table",
 "key col",
 "logon user"
)

should return yes to the user who matches your requirement assuming "your table" has [logon date] and [logon user] columns.