Forum Discussion

ibarraza's avatar
ibarraza
New Member
6 years ago
Solved

create table with unique values from another table columns

Hello Everyone!   I am pretty new to Power BI so any help is highly appreciated. I have a table (called survey) with answers IDs and the corresponding answers. If the person surveyed worked in one ...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi ibarraza ,

     

    Try this code:

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUQpOzEktBtJ5pTk5QMotMy8xLzlVKVYnWskIIeybWJSdWpKZlw4TAskbI2lHVgA3IxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Answer ID" = _t, Sales = _t, Marketing = _t, Finance = _t]),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {"Answer ID"}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Columns",{"Attribute"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([Value] <> "null"))
    in
    #"Filtered Rows"

     

    Ricardo

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi ibarraza ,

 

Try this code:

 

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUQpOzEktBtJ5pTk5QMotMy8xLzlVKVYnWskIIeybWJSdWpKZlw4TAskbI2lHVgA3IxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Answer ID" = _t, Sales = _t, Marketing = _t, Finance = _t]),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {"Answer ID"}, "Attribute", "Value"),
#"Removed Columns" = Table.RemoveColumns(#"Unpivoted Columns",{"Attribute"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([Value] <> "null"))
in
#"Filtered Rows"

 

Ricardo

  • ibarraza's avatar
    ibarraza
    New Member
    6 years ago

    Thank you so much Ricardo

     

    I needed to see the steps in M to apply it to a similar table.

     

    Thank you