how to convert this from XL to power query countif

[Miss_A]

I have duplicated ID. I want to count the duplicate value for 1st ID= 1, 2nd ID= 2, 3rd ID =3 in power query. how to count for this. 

[AlienSx · Accepted solution]

@Miss_A 

    g = Table.Group(Source, {"Code"}, {{"rows", each Table.AddIndexColumn(_, "UniquedCount", 1, 1)}}),
    z = Table.Combine(g[rows])