Forum Discussion
Index Key
Hi glmoon5 ,
Thanks for reaching out to Microsoft fabric Community Forum.
Based on the sample data as you provided as per the query :- You can create a Geography-based index in Power BI by first sorting the data by Geography.
- Then removing duplicates from a duplicated Geography column, adding an index to that unique list, and finally merging it back with the original table to assign a consistent index per Geography group.
Expected output :
Reference : Add an index column - Power Query | Microsoft Learn
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
I have a Top_20 table that has [Geographies] as a column listed multiple times because the table also contains Product UPCs and associated sales with them.
I need to create an index on the [Geographies] column so that the index stays the same until a new geography shows in the table. How can I achieve this??
Hi glmoon5 ,
Thanks for reaching out to Microsoft fabric Community Forum.
Based on the sample data as you provided as per the query :
- You can create a Geography-based index in Power BI by first sorting the data by Geography.
- Then removing duplicates from a duplicated Geography column, adding an index to that unique list, and finally merging it back with the original table to assign a consistent index per Geography group.
Expected output :
Reference : Add an index column - Power Query | Microsoft Learn
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Hi glmoon5 ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!
Hi glmoon5 ,
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi glmoon5 ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!