Comparing data in same data set

[divumj]

Hi all

I am trying to find the rows where balances are exactly same and against that I have to add comments some thing like match.

For e.g.

S.no. name balance comment

1.      Mohit.  100.      Match

2.      Neha.    200.     No match

3.      Sunita.   100.     Match

Any suggestions please...

Regards

Mohit Jain

[AlienSx]

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLNz8gsAdKGBgZKsTrRSkZAtl9qRiKQMoIKGQPZwaV5mSWJMHWxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [S.no = _t, name = _t, balance = _t]),
    group = Table.Group(
        Source, 
        "balance", 
        {{"all", each _}, {"comment", each Table.RowCount(_)}}
    ),
    match = Table.TransformColumns(group, {"comment", each if _ = 1 then "No match" else "Match"}),
    expand = Table.ExpandTableColumn(match, "all", {"S.no", "name"})
in
    expand

[divumj]

@AlienSx 

Thanks for suggestion it worked but partially...it gave me match...but we need match combination number as well to identify the exact item matching..

Any suggestions for that please it will be great help

[dufoq3]

You should provide sample data and expected result based on that.