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:
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