Forum Discussion
WheelchairWilly
Helper III
Helper IIIHow to make a 1-20 column
I want to show a 1-20 column that stays the same, only the teams move up/down. . So Arsenal in the screenshot is 1 whereas Sunderland here would be 20. How would I go about composing this column? ...
Ah, got it now 😄. If you just need a fixed 1-20 column regardless of points or position, the simplest option is to create an Index Column in Power Query.
Transform Data → Add Column → Index Column → From 1
That will give you a permanent 1-20 numbering column that stays the same, while the team names and stats can change each gameweek.
WheelchairWillyHelper III
Helper IIIThat didnt work Shar. I would point out that because the points will change every week so dont worry about the teams position etc. I just want a column before GW which shows 1 right trrough to 20 down that column.
Ashish_Mathur
Super User
Super UserHi,
This visual calculation should work
=rownumber(rows)
Hope this helps.