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!
then could you pls proivde some sample data and expected output? We don't need top 20, maybe just top 3 or top 5 sample data
I don't have the data handy.....I was thinking this was pretty straight forward for someone how knows more about PBI that me?
It's difficult to provide a solution without a sample data and the expected result from that. It's like trying to hit a target without properly aiming at it.
How about this:
Geography Brand Dollar Sales GEO 1 BRAND 1 $16,789,338 GEO 1 BRAND 2 $9,911,549 GEO 1 BRAND 2 $5,022,607 GEO 1 BRAND 4 $5,694,625 GEO 1 BRAND 5 $19,823,097 GEO 1 BRAND 6 $5,084,486 GEO 2 BRAND 1 $60,139,860 GEO 2 BRAND 2 $44,031,651 GEO 2 BRAND 2 $31,547,579 GEO 2 BRAND 4 $5,544,625 GEO 2 BRAND 5 $22,015,826 GEO 2 BRAND 6 $21,490,223 Hi,
Based on the table that you have shared, show the expected result very clearly.
