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

Tiger1
Participant V

I have a table:
3X_4_a_4a17aebeb74a603eadb75b44bf9861374ef20468.png

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

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

but i get this error:

Solved Solved
0 3 195
1 ACCEPTED SOLUTION

LeventK
Participant V

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])

View solution in original post

3 REPLIES 3

LeventK
Participant V

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])

Worked great. Thank!

You’re welcome.

Top Labels in this Space