Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear Power Query community,
I would like to obtain a table containg, for each individual Source, all the Type-Num in 1 cell.
Left side is what I get when I analyze ma data via a Pivot Table. Not exactly what I want.
Is there an easy way with Power Query to transform the data and get what I want?
Thank you
Solved! Go to Solution.
You can group by in Power Query, your original dataset can do Concat in DAX and show the result in visual as well
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ1NPY3M4xS0lFycvaN0DU0NzYwV4rVwZQxBspgSgRE6JoYGlogSVgEwnVYWpoqxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Source = _t, #"Type-Num" = _t]),
#"Grouped Rows" = Table.Group(Source, {"Source"}, {{"Type-Num", each Text.Combine(_[#"Type-Num"],";")}})
in
#"Grouped Rows"
You can group by in Power Query, your original dataset can do Concat in DAX and show the result in visual as well
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ1NPY3M4xS0lFycvaN0DU0NzYwV4rVwZQxBspgSgRE6JoYGlogSVgEwnVYWpoqxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Source = _t, #"Type-Num" = _t]),
#"Grouped Rows" = Table.Group(Source, {"Source"}, {{"Type-Num", each Text.Combine(_[#"Type-Num"],";")}})
in
#"Grouped Rows"