New help with row counts

[Anonymous]

hello from this table I have repeated [Puesto] but with different [Agrupador] I need to create another table with only the ones repeated with their respective [Agrupador] how can i do this in power Query? note:this is sample data

57	AFANADOR S (TC)	Administración
58	AGENTE ATENCION TELEFONICA MULTISKILL	Checa
59	AGENTE ATENCION TELEFONICA PAGOS	Checa
60	AGENTE ATENCION TELEFONICA RETENCION	Checa
61	AGENTE ATENCION TELEFONICA TECNICO	Checa
62	AGENTE ATENCION TELEFONICA TECNICO CABLE ACCESS	Checa
63	AGENTE ATENCION TELEFONICA TECNICO TELEFONIA	Checa
64	AGENTE ATENCION TELEFONICA VENTAS	Checa
65	AGENTE ATN. TELEFONICA MULTISKILL	Checa
66	AGENTE ATN. TELEFONICA PAGOS MT	Checa
67	AGENTE ATN. TELEFONICA PYME	Checa
68	AGENTE ATN. TELEFONICA TEC.	Atencion a Clientes
69	AGENTE ATN. TELEFONICA TELECOM MT	Checa
70	AGENTE ATN. TELEFONICA VENTAS	Checa
71	AGENTE CAS (TVI)	Administración
72	AGENTE CAS PREMIUM (TVI)	Administración
73	AGENTE DISPATCH (TVI)	Monitores
74	AGENTE SERV. CLIENTE (TVI)	Checa
75	AGENTE SERV. CLIENTE 2 NIVEL (TVI)	Checa
76	AGENTE SUC. (TVI)	Administración
77	AGENTE SUC. (TVI)	Atencion a Clientes
78	AGENTE SUC. (TVI)	Ventas
79	AGENTE SUC. INCAPACIDAD (TVI)	Atencion a Clientes
80	AGENTE VALIDACION IZZI (TVI)	Checa
81	AGTE. ATN. TELEFON. TEC. CABLE ACCESS	Checa
82	ALMACENISTA	Administración
83	ALMACENISTA (CM)	Administración
84	ALMACENISTA (TC)	Administración
85	ALMACENISTA (TVI)	Administración
86	ALMACENISTA A (CC)	Administración
87	ALMACENISTA B (CC)	Administración
88	ALMACENISTA B (CC)	Administración
89	ALMACENISTA DESPACHADOR (CM)	Administración

[v-frfei-msft]

Hi @Anonymous ,

Group the table by [Puesto] & [Agrupador] in power query .

For more details, please check M code as below.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("lZXRTsIwFIZfpdmVJmRRBFouj2cVGtuObGWJGi8ILnGJjgR4Mx/BF7MbaNZJK14ttN+3nZ7/bDw9RWMaDSK4Aw1JmpGcXBi8bFZe3qu62u23q3X1+VFHzwOLsmZjxrXhBAzXKFJNDJf8LtUCgailNCK/F1JaDl/L9eqgTcPaAmZp7hiTq7CR8eOia12HLcPRXlPXGZ7lEIRbaQlEnvdKvTnvBt9L4NqjsF3YHeg9cNxVdHxGAJOJX2mbT5RxBRoQHhR3YeaH7enjZndf1utqU5MVwbeqrPfl7qBOQ6rkmKp+afTKr5zoFu3MBEIz3YXwjTcduuwi40osVdjpxJ+IfAEG5z+C2tTVfrM9HpZ2ss55VsQEpWh/ffOdssc+dki0KLg85XRSzpcYh+umPtgTFWUeobDM6shMe4zQCAtAkUDy5wNYJ9gCpHXal0E8PooTh2WHXA2PnSmI24nzv62sjVgqQK5FbsDTHXbjYuQCla+TbNRn/R9QNv7F+iNikx7clOG/Ne3Rt0Ga/Yue9uiE20nHefuP4WvN8xc=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ID = _t, Puesto = _t, Agrupador = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Puesto", type text}, {"Agrupador", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Puesto", "Agrupador"}, {{"Count", each Table.RowCount(_), type number}})
in
    #"Grouped Rows"

If it doesn't meet your requirement, kindly share your excepted result to me.

[Anonymous]

sorry [Puesto] is the second Column and [Agrupador] the third one