Forum Discussion

ODash's avatar
ODash
Regular Visitor
6 years ago
Solved

Combing Data Fields

Hi,   I'm relativly new to Power BI and am at the exploring stage to see if it can work for me.   I've got to a point of I know what I'd like to do, but not even sure if it's possible, so hopeful...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi ODash ,

     

    You can also use the unpivot feature and remove empty feature in Query Editor.

    Please check the following steps.

    1. Select the tree columns and click unpivot.

    2. Click the buttom at the right of value column and click remove empty.

    3. Remove the Attribute column.

    The result would be shown as below.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi ODash ,

 

You just need to unpivot the other columns.

 

Here is the code, just past on Advanced Editor on Power Query:

 

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXIEYicgdlaK1YlWMoLyFMAYJGIMloOog4iYwHlgkVgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Ref = _t, #"Aspect 1" = _t, #"Aspect 2" = _t, #"Aspect 3" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Ref", Int64.Type}, {"Aspect 1", type text}, {"Aspect 2", type text}, {"Aspect 3", type text}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Ref"}, "Attribute", "Value"),
#"Filtered Rows" = Table.SelectRows(#"Unpivoted Other Columns", each ([Value] <> " "))
in
#"Filtered Rows"

 

Ricardo