Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a Table with All Possible Combos from a Single Column and Data for Each Combo

Hi everyone,   Posting here for the first time. This forum has helped a lot over the past few months of learning Power BI. I could use some help with something that I haven't seen in my googling. ...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

This increases the complexity of the ask by at least an order of magnitude.  What you are basically asking is

 

"given a list of items, find all unique combinations across all the items in the list" 

 

My previous solution proposal assumed that you had four items in your list, but now this is becoming a dynamic size. It will take some time to refactor the code for this. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yeah, I think that sounds about right. Basically for SuperGroup A, I'd like to see all combos of Groups 1,2,3,4; for SuperGroup B, all combos of Group 5 (so just one); and for SuperGroup C, all combos of Groups 6,7. There will never be more than four Groups in a SuperGroup though so at least the number of columns would be constant. Thanks for all the help with this!