Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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.
sorry [Puesto] is the second Column and [Agrupador] the third one
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.