Get an id column with unique value for each row using dax

[Anonymous]

Hi All,

I have Table 2 with buyer_name column. I am trying to get an id column that uniquely defines each row in my table. Even if the buyer_name is same, i want unique row id.

I tried  using

Row Number1= = RANKX('Table 2','Table 2'[buyer_name],,ASC)

but it gives same id for same buyer names. I don't want that. Below is what I want my ids to be-

[Anaxielia1]

The query you wrote in your post gave a solution to my search, i wanted to thank you 🙂

[Weegreen]

Hi, similar issue here although I don't believe I can achieve in the same way.

I have a list of dates which I need to order and rank in exactly the manner as above, but when slicers are applied these numbers need to recalculate based on the range now available. There are duplicate dates in this list which need given numbers different to one another. I drew a sketch for a friend as below, any help would be massively appreciated!!!

 

[bcdobbs]

I would do that in power query (transform data) and add an index column (available in the ribbon).

[Anonymous]

@bcdobbs, Table 2 is a calculated table, so I cannot edit it in Power query.

[v-xiaosun-msft]

Hi @Anonymous ,

You can use "copy table" in "data view" and then you can edit your table in Power Query.

Please follow these steps.

Select your table in "data view", click "copy table". Then select "Create Table" and paste it.

Then you can process it in Power Query.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.