How do i use MAXROW() to give me the latest row ONLY in this table example?

I have a table:
image

I tried this expression:
MAXROW(
“Messages”,
“_ROWNUMBER”
)

to give me the latest row (last on the spreadsheet)

but i get this error:

You can’t use MAXROW() as a slice condition as it returns REF values, not a boolean (TRUE/FALSE) value. Try with:
[_RowNumber] = MAX(TableName[_RowNumber])

2 Likes

Worked great. Thank!

1 Like

You’re welcome.