Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I was able to create new table using distinct values but i was not able to create index column in this new table.
Product_Table = DISTINCT('Table'[Product])
Thanks,
Hari
Solved! Go to Solution.
Try it in Power Query. Do a GROUP BY on a copy (ore REFERENCE) of the original table. From there you can add an Index column.
Question back to you: Of what use is the INDEX column? You can't reference it like a Primary Key/Foreign Key relationship because no other table know the values. And the order of the index is not controllable, other than by preceding it with a SORT operation in Power Query.
Proud to be a Super User! | |
Try it in Power Query. Do a GROUP BY on a copy (ore REFERENCE) of the original table. From there you can add an Index column.
Question back to you: Of what use is the INDEX column? You can't reference it like a Primary Key/Foreign Key relationship because no other table know the values. And the order of the index is not controllable, other than by preceding it with a SORT operation in Power Query.
Proud to be a Super User! | |
User | Count |
---|---|
85 | |
81 | |
64 | |
53 | |
46 |
User | Count |
---|---|
101 | |
49 | |
42 | |
39 | |
38 |