Assign to each unique value a number

[mclarke]

Hi guys,

I'm trying to assign a numerical code (consecutive ideally but not necessarily) for each unique value from a column. Is there a way to do this?

I hope you can help me!!

[ribisht17]

@mclarke 

Please post some sample data here

Regards,

Ritesh

[ribisht17]

@mclarke 

You can definitely add INDEX column 

Solved: Rank for unique values - Microsoft Power BI Community

Regards,

Ritesh

[mclarke]

Thank you for answering. This generates a new value for each row, I need only new numbers on new values

[ribisht17 · Accepted solution]

@mclarke 

Like this ?

Please use this >>> 

RANKXC = RANKX(Sheet4,Sheet4[Category],(Sheet4[Category]))

Regards,

Ritesh

[mclarke]

Thank you! I've sorted it another way (duplicated column in another table, removed duplicates and indexed), but this is even better.