Forum Discussion
Create unique ID
Hi I have one table DimEmployee with employee data and it contains column named Country . I want to create calculated column to generate unique key for each country. so in below example column li...
Yes just use Rank
this will give them a unique id based on alphibetial order of country
Column =RANKX(Table1,Table1[Country],Table1[Country],ASC,Dense)
I want to do it dynamically and I do not have any country table so I want to do this in DimEmployee itself. Is it doable ?
Yes just use Rank
this will give them a unique id based on alphibetial order of country
Column =
RANKX(Table1,Table1[Country],Table1[Country],ASC,Dense)