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

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 197
1 ACCEPTED SOLUTION

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

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