Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Thanks for responding.
Expected output attached
Index will add unique record for all rows.
I need unique id column based on unique values from both storeid and productid
Sorry,
But according to your example these are just random numbers.
Provide more sample data so we can better understand the expected outcome.
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |