Just thinking this must be simpler.
I am cycling through a set of Actions to insert a computed number of Teams. So, I know the number of teams to add and to determine if I have inserted the correct number, I am tracking a Team # value. Once this Team # matches my expected number of team to be inserted, I know I am done.
With each iteration, I want to grab the Team row with the maximum Team # and then simply add 1 to it.
I can get the maximum Team # row like so:
MAXROW("Teams", "Team #", [Challenge] = [_THISROW].[Challenge ID])
This returns a row reference to that Team row. Is there some straight-forward way to dereference the Team # value from row reference?
So far the best I could figure out is that I need to do the below but it seem unnecessarily repetitive.
ANY(SELECT(Teams[Team #], [Team ID] = MAXROW("Teams", "Team #", [Challenge] = [_THISROW].[Challenge ID])) ) + 1