How to Rank the Data for each Group in Power Query
How to apply Rank for each Group of Data in Power QueryScenario:Suppose we have the Sample dataset with columns as Product Segment, Product Name and Order Quantity as follows:Now we want to apply the Ranking for the Order Quantity sort by Descending for each Product Segment sort by Ascending Order.We can achieve this Scenario using the following Power Query:let SourceData = "
https://excelkingdom.blogspot.....com/2024/05/how-to-r
Discover the world at Altruu, The Discovery Engine