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.
ShahRukhSameer
Continued Contributor
Continued ContributorHi WheelchairWilly,
You can create this as a measure rather than a calculated column. If you want the teams to move up/down based on their Points, use:
Position =
RANKX(
ALLSELECTED('Teams'[Home Team]),
[Points],
,
DESC,
DENSE
)
Then add the Position measure to your table.
If you also need Goal Difference and other league rules to break ties, you can include those in the ranking logic as well.