Try using Sort on the table to ensure your IDs are in order, then use First or Last as appropriate to pick the one you want.
_________________________________________________________________________________________ Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
I suggest using First(Sort(LikeVideo,EmployeeID,Descending)).EmployeeID+1. Make sure that EmployeeID is a number type column. Max() and Last() are not delegatable, meaning that once you exceed the maximum number of items (500 default, 2000 maximum), the result will not be correct.