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.
I am trying to group by [case],[case status] and [case practice] and create a list from [title], fiddiling around with power query but cannot figure out how to group AND create a list, can anyone please help?
Solved! Go to Solution.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXLMS8ypLC5RitWJVjIC8n0T8xLTU4vgfHR5l8yi1OSSfIgCY5CC4uL85MzEklSl2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Case = _t, Title = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Case", Int64.Type}, {"Title", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Case"}, {{"Rows", each _, type table [Case=nullable number, Title=nullable text]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Title", each Text.Combine([Rows][Title],",")),
#"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Case", "Title"})
in
#"Removed Other Columns"
How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXLMS8ypLC5RitWJVjIC8n0T8xLTU4vgfHR5l8yi1OSSfIgCY5CC4uL85MzEklSl2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Case = _t, Title = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Case", Int64.Type}, {"Title", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Case"}, {{"Rows", each _, type table [Case=nullable number, Title=nullable text]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Title", each Text.Combine([Rows][Title],",")),
#"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Case", "Title"})
in
#"Removed Other Columns"
How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
Thank you so much!
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.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |