How to specify Last -1?

Hi there, does anyone know if there’s a way to specify the second from last in a list? Something like last(-1)? I’m trying to filter a table to show only the highest version number and the second highest version number.

You can do something like this:
image

Using the nth() formula to locate the (list count - 1)

3 Likes

Hello @Tim_Richardson1 and @Scott_Collier-Weir!
The formula @Scott_Collier-Weir gave could also work without the Table.Count()

Table.Nth(-2)

Cheers!

5 Likes

Thank you! I could have sworn I tried that, but i guess i didn’t do it right. Thank you!

1 Like