Forum Discussion
groupby function in power query editor
Hello,
I am working on power query editor. I have a table with multiple columns. I need to group "team member names"* (in a comma seperated foormat) by the "team name"* (which is repeating) and keep data of other columns same as it as repeating with "team name".
Kindly help me find the solution.
(Table: contains 10 columns, 8 text* and 2 decimal data type)
Hi PriyankaBhamare ,
Please try:let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("VY07DoAgEAXvQk2hCGKLeAtCgf9G71+Ku5voKzabSSbzUlIhKK3ucm1t/W3TvK/IEWb9k8wnzXIVDUnjKFKHpYWxIylGkSyWVkaLcw5LG6PDuR5LO2OPcx5LB6MnaZpEGrB0Mg4q5wc=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"team name" = _t, #"team member names" = _t, #"other column1" = _t, #"other column2" = _t, #"other column3" = _t, #"other column4" = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"team name", type text}, {"team member names", type text}, {"other column1", Int64.Type}, {"other column2", type text}, {"other column3", type text}, {"other column4", Int64.Type}}), #"Grouped Rows" = Table.Group(#"Changed Type", {"team name"}, {{"team member names", each Text.Combine(List.Distinct([team member names]),",")}, {"Data", each _}}) in #"Grouped Rows"Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
1 Reply
Hi PriyankaBhamare ,
Please try:let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("VY07DoAgEAXvQk2hCGKLeAtCgf9G71+Ku5voKzabSSbzUlIhKK3ucm1t/W3TvK/IEWb9k8wnzXIVDUnjKFKHpYWxIylGkSyWVkaLcw5LG6PDuR5LO2OPcx5LB6MnaZpEGrB0Mg4q5wc=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"team name" = _t, #"team member names" = _t, #"other column1" = _t, #"other column2" = _t, #"other column3" = _t, #"other column4" = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"team name", type text}, {"team member names", type text}, {"other column1", Int64.Type}, {"other column2", type text}, {"other column3", type text}, {"other column4", Int64.Type}}), #"Grouped Rows" = Table.Group(#"Changed Type", {"team name"}, {{"team member names", each Text.Combine(List.Distinct([team member names]),",")}, {"Data", each _}}) in #"Grouped Rows"Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group