1 ACCEPTED SOLUTION
In Power Query make a copy of your existing table and remove all the columns except the name. Remove duplicate values then add an index column, then use Merge as new to merge the original query with the list of unique names. Expand the merged table to bring in the index column.
Finally, you can untick the Enable Load option for the original query and the unique names, so only the merged table is pulled into your model.
The following calculated column should work
NameRank =
RANKX(
DISTINCT('Table'[Name]),
CALCULATE(MIN('Table'[Name])),
, ASC, DENSE
)
In Power Query make a copy of your existing table and remove all the columns except the name. Remove duplicate values then add an index column, then use Merge as new to merge the original query with the list of unique names. Expand the merged table to bring in the index column.
Finally, you can untick the Enable Load option for the original query and the unique names, so only the merged table is pulled into your model.
In M group by the name (and keep the rows), add an index column, and then expand the rows back out.
