cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
beyanora New Member
New Member

Creating a table of each tuple from two lists

Dear Power BI community,

 

I'm trying to convert two lists into a table, like so (source lists on the left, desired result on the right):

 

Untitled.png

 

Each element of each list must be combined with every other element. I'm struggling to put it in words, hopefully the image explains what i want.

 

How to do this in Power BI?

 

I found List.Zip, that seems to work, but I get a resulting column with lists, and I don't know how to expand each of them.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Creating a table of each tuple from two lists

@beyanora,

 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/New-Table-based-on-combination-of-column-values-from-other/...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Creating a table of each tuple from two lists

@beyanora,

 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/New-Table-based-on-combination-of-column-values-from-other/...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.