Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
MYasim
New Member

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

1 ACCEPTED SOLUTION

Hi @MYasim 

 

It should be [Sorted Group]. You are missing the space character between two words.

vjingzhang_0-1686215808475.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

3 REPLIES 3
v-jingzhang
Community Support
Community Support

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.Northwind Products Data.pngFirst Grouped column.pngSecond Sorted Grouped column.pngit says SortedGroup not foundit says SortedGroup not found

Hi @MYasim 

 

It should be [Sorted Group]. You are missing the space character between two words.

vjingzhang_0-1686215808475.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors