Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |