Livio/ August 3, 2018/ Power BI, Power Query/ 3 comments

Generating Combinations in Power Query

In this post I wanted to share the function I have created to generate combinations in Power Query. The function will accept two parameters. The first parameter is a list you want to use to generate the combinations, the second parameter is a number representing the number of items for each combination. 

In terms of speed there is probably room for improvement as the function may take a few minutes for very large combinations. I will probably revisit it again in the future but for the moment it gives me the results I wanted. Also it would be good if someone can suggest how it could be sped up for large combinations.

The function:

 

Calling the function:

I will show below how to call the function and the preview of the results you would get

 

let Source = {"Red","Green","Yellow","Brown","Black","Purple","Pink","Blue","Orange"} in fnGenerateCombinations(Source,4)

Combinations in Power Query

 

 

Combinations in Power Query

Combinations in Power Query

 

Of course you are not limited to a list containing text, it could very well be a list of number, or a list of records, or a list of tables or a list of lists.

Livio

 

3 Comments

  1. Very informative article, great work
    thanks for sharing, Keep up the good work!

    1. Thank you Shobi! Your feedback is very much appreciated.

  2. It would be very helpful if you could make a tutorial..

Leave a Comment

Your email address will not be published.

*
*