Forum Discussion

heureso's avatar
heureso
New Member
7 years ago
Solved

Combine two list columns from same table

I have one table with two List columns.   Each List contains Records, and the Records from each column have the same fields.   I am trying to combine the two Lists for each row into a superset, t...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    heureso add custom column to combine both lists using following expression and then expand this new column, i believe that is what you are looking for

     

    List.Combine({[List1],[List2]})
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

Anonymous Use list.zip

 

List.Zip({[List1 Column], [List2 Column]})

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi parry2k,

    Thanks for the reply.

     

    When I try using list zip:

    each List.Zip({[Lease Numbers List],[Size List]})

    It results in 3 rows but the result is just

     

    To clarify the columns within the List Zip have lists in each cell,

     

    Any additional thoughts?