Generate UniqueID column based on 2 existing columns

Question

Hi&nbsp;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.&nbsp;I'm trying to do this in power query edit mode.&nbsp;Request to please help on the same.&nbsp;Thanks

anonymous · Answer

Hi&nbsp;satishkurra&nbsp;What is the expected results?Can you provide some examples?Ta

satishkurra · Answer

Thanks for responding.&nbsp;Expected output attached

anonymous · Answer

So,It is a random number?How about adding an index column?https://youtu.be/hhZ04by1UuQ&nbsp;&nbsp;

satishkurra · Answer

Index will add unique record for all rows.&nbsp;I need unique id column based on unique values from both storeid and productid

anonymous · Answer

Sorry,But according to your example these are just random numbers.Provide more sample data so we can better understand the expected outcome.&nbsp;

Forum Discussion

Generate UniqueID column based on 2 existing columns

6 Replies

Related content

Generating Missing Data

Generating link

Lakehouse Table Generate Create Table

Use existing measure to generate Average Days Outstanding

How to copy existing semantic model ?