Forum Discussion
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. ...
See attached for a solution with SuperGroups
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.
See attached for a solution with SuperGroups
Ingenius! I didn't know you could create functions within Power Query. This worked perfectly with my much larger dataset. Thank you so much!