How to get a unique number for a group of duplicates in a list?

[Mushwar]

Hi all, I'm working on a org.chart and I've gotten my hands on a csv extraction from our AD servers. I've gotten all the names, accountnames, relations between bosses and employees and such. Though for my organisation tree to work I need to have each group of NAME? to be assigned a unique number. For example 10xNAMEy=nr1 and 15xNAMEz=nr2 and so on. 

Basically in this list of hundreds and hundres of rows, each employee is unique but they share managers, therefore I need these groups of managers to be assigned a number so I can map these groups in a org.tree visual. 

Does any of this make any sense? English isn't my first language and I'm new to PowerBI so I doesn't fully grasp the lingo yet. 

[v-eachen-msft]

Hi @Mushwar ,

You could use RANKX() function to create unique numbers based on name column.

You could share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to OneDrive and share the link here.

[vivran22]

Hello,

Is it possible to share sample data and the desired output required?

Regards,
Vivek

[MariusT]

You can remove duplicates in the query editor, and then add an index, but I am not sure if this is the most correct way to solve your problem.

Would it be possible for you to provide som sample data?

[RobbeVL · Accepted solution]

Hi,
If you need a unique Identifier, the most usefull way would be to paste together a range of columns, that together make a Unique Key. this way the key is also readable. 

Alternatively, you could just add an Index column in PowerQuery. 

FYI, it is also possible to directly connect to your Active user directory with Power BI, this might be usefull when you want your report to dynamically change to the actual state of the company.

Regards,

Robbe