Grouped stock ranking

Your manager wants you to revisit the ranking of products by their stock levels. This time, they are interested in finding the product with the highest stock value for each of the categories that are stocked. This is similar to the step you already carried out however there is a subtle but important difference.

Let's see how we can use an advanced custom column together with the group by feature to accomplish this.

If you lost any progress, load the workbook 3_3_stock_grouped_rank.pbix from the Exercises folder on the Desktop.