Generate UniqueID column based on 2 existing columns

[satishkurra]

Hi

Below is the snapshot of sample data. I need to generate distinct/unique ID column (this will be a new column in the same table) based on the 2 columns storeID and productID.

I'm trying to do this in power query edit mode.

Request to please help on the same.

Thanks

[Anonymous]

Hi @satishkurra 

What is the expected results?
Can you provide some examples?

Ta

[satishkurra]

Thanks for responding.

Expected output attached

[Anonymous]

So,

It is a random number?

How about adding an index column?
https://youtu.be/hhZ04by1UuQ

[satishkurra]

Index will add unique record for all rows.

I need unique id column based on unique values from both storeid and productid

[Anonymous]

Sorry,

But according to your example these are just random numbers.

Provide more sample data so we can better understand the expected outcome.

[satishkurra]

Hi

These are not just random numbers. It created unique id for Key field 1,2,3,4 for unique combination of Storeid and productid.

Here is the sample data. 

StoreID	ProductID
1	1
1	2
1	1
1	2
2	1
2	2
2	1