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.
Hi to all,
I have the following table:
I need to transpose it into
One row per Job, a column with Quantity, H1 and H2 for each phase.
Thanks!
Solved! Go to Solution.
pls this
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXJKzUsBUh4gtqEBkDAyUIrVQZUzgskhpJxLS2C6jEyBhLEJupQRxCyYJiNUTYaWQMIEXcYIJgPUEwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Job = _t, Phase = _t, Type = _t, Hours = _t, Quantity = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Job", Int64.Type}, {"Phase", type text}, {"Type", type text}, {"Hours", Int64.Type}, {"Quantity", Int64.Type}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Job", "Phase", "Type"}, "Attribute", "Value"),
#"Merged Columns" = Table.CombineColumns(#"Unpivoted Other Columns",{"Phase", "Type", "Attribute"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"type.1"),
#"Pivoted Column" = Table.Pivot(#"Merged Columns", List.Distinct(#"Merged Columns"[type.1]), "type.1", "Value", List.Sum)
in
#"Pivoted Column"
pls this
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXJKzUsBUh4gtqEBkDAyUIrVQZUzgskhpJxLS2C6jEyBhLEJupQRxCyYJiNUTYaWQMIEXcYIJgPUEwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Job = _t, Phase = _t, Type = _t, Hours = _t, Quantity = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Job", Int64.Type}, {"Phase", type text}, {"Type", type text}, {"Hours", Int64.Type}, {"Quantity", Int64.Type}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Job", "Phase", "Type"}, "Attribute", "Value"),
#"Merged Columns" = Table.CombineColumns(#"Unpivoted Other Columns",{"Phase", "Type", "Attribute"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"type.1"),
#"Pivoted Column" = Table.Pivot(#"Merged Columns", List.Distinct(#"Merged Columns"[type.1]), "type.1", "Value", List.Sum)
in
#"Pivoted Column"
User | Count |
---|---|
92 | |
86 | |
66 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |