How to Rank the Data for each Group in Power Query | Power BI Analytics Kingdom

let

    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(SourceData, BinaryEncoding.Base64), Compression.Deflate)), 

        let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ProdSegment = _t, ProdName = _t, OrderQnty = _t]),

    ChangedType = Table.TransformColumnTypes(Source,{{“ProdSegment”, type text}, {“ProdName”, type text}, {“OrderQnty”, Int64.Type}}),

    SegmentGroupData = Table.Group(ChangedType, {“ProdSegment”}, {{“ProdSegGroup”, 

        each _, type table [ProdSegment=nullable text, ProdName=nullable text, OrderQnty=nullable number]}}),

    RankQnty = Table.AddColumn(SegmentGroupData, “RankByProdQnty”, each Table.AddRankColumn([ProdSegGroup], 

        “RankProdQnty”,{{“ProdSegment”,Order.Ascending},{“OrderQnty”,Order.Descending}},[RankKind = RankKind.Dense])),

    SelectColumns = Table.SelectColumns(RankQnty,{“RankByProdQnty”}),

    ExpandRankByProdQnty = Table.ExpandTableColumn(SelectColumns, “RankByProdQnty”, 

        {“ProdSegment”, “ProdName”, “OrderQnty”, “RankProdQnty”}, 

        {“Prod_Segment”, “Prod_Name”, “Order_Qnty”, “Rank_ProdQnty”})

in

    ExpandRankByProdQnty