Create A Calculated Column With Number for Unique Text

[tksnota01]

Hi,

I have hundred of names and I need to create numbers to represent each of them as shown 

Are there DAX or M Code I can use?

Thanks...tksnota01...

A 1
B 2
C 3
D 4

B 2

D 4

[Cookistador]

The following calculated column should work

NameRank =

RANKX(
DISTINCT('Table'[Name]), 
CALCULATE(MIN('Table'[Name])), 
, ASC, DENSE 
)

[johnt75 · 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.

[lbendlin]

In M group by the name (and keep the rows), add an index column, and then expand the rows back out.