Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am trying to sort grouped tables in power query, as part of an assignment from datacamp. First there were instructions to right click on grouped column, then click on add custom column. But there is only custom column from examples option only. Secondly when I try to make index column, using table.addindexcolumn for a grouped column that I sorted using table.sort then it gives me error in entire column. The formula I used for table.sort is:
Table.Sort([Grouped],{{"StockPlusOrderValue", Order.Descending}})
I used for table.addindex:
Table.AddIndexColumn([SortedGroup], "CategoryGroupedRank", 1, 1)
But now it is giving me entire column error
Please help if someone knows a solution
Solved! Go to Solution.
Hi @MYasim
It should be [Sorted Group]. You are missing the space character between two words.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @MYasim
Can you please provide some sample data to help clarify what you have currently and what you want to achieve?
The formula looks correct. What is the error message after you used Table.AddIndexColumn([SortedGroup], "CategoryGroupedRank", 1, 1)? You can click the "Error" in a cell to see the detailed error message.
Best Regards,
Community Support Team _ Jing
Sure, here I will share screenshots. It is northwind products data, hope this helps. I couldn't find an option to share files.
Hi @MYasim
It should be [Sorted Group]. You are missing the space character between two words.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
62 | |
54 | |
27 | |
16 | |
13 |