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

So now that I think about this again, I think what you originally provided solved "given a list of items, find all unique combinations across all the items in the list." The problem though is that I have a list of >20 items and it will continue to grow, so the size of the table is exploding. I only want to look at combinations of items with the SuperGroups to limit the number of combos to anywhere from 1-15 combos per SuperGroup.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Ingenius! I didn't know you could create functions within Power Query. This worked perfectly with my much larger dataset. Thank you so much!