Forum Discussion
Grouped Stock Ranking problem
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
Hi Anonymous
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.
3 Replies
v-jingzhangCommunity Support
Hi Anonymous
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- v-jingzhang
Hi Anonymous
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.