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.
Hi,
I currently have the below format of data:
I would like to get it to look like something like this:
I tried to pivot columns and it gave me this:
Solved! Go to Solution.
Hi @ChrisHedges,,
Something like this?
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLKz8hTitWJVjICcRKTs8EcYyAnILE0B84Jy0zOrkSoy1eKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [incremental_id = _t, name = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"incremental_id", Int64.Type}, {"name", type text}}),
#"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "incremental_id", "incremental_id - Copy"),
#"Pivoted Column" = Table.Pivot(#"Duplicated Column", List.Distinct(#"Duplicated Column"[name]), "name", "incremental_id - Copy", (x)=>List.ContainsAny(#"Duplicated Column"[#"incremental_id - Copy"], x))
in
#"Pivoted Column"
Kind regards,
John
Hi @ChrisHedges,,
Something like this?
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLKz8hTitWJVjICcRKTs8EcYyAnILE0B84Jy0zOrkSoy1eKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [incremental_id = _t, name = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"incremental_id", Int64.Type}, {"name", type text}}),
#"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "incremental_id", "incremental_id - Copy"),
#"Pivoted Column" = Table.Pivot(#"Duplicated Column", List.Distinct(#"Duplicated Column"[name]), "name", "incremental_id - Copy", (x)=>List.ContainsAny(#"Duplicated Column"[#"incremental_id - Copy"], x))
in
#"Pivoted Column"
Kind regards,
John
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.