Blog Post

Power BI Community Blog
3 MIN READ

Combinatorics in Power Query -part1

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago
Combinatorics is one of the most important areas of data analysis. It helps in painting a meaningful picture from tons of data very quickly. We are often faced with a situation when we need to quic...
Updated 4 years ago
Version 8.0
how to
tips & tricks
smpa01's avatar
Icon for Community Champion rankCommunity Champion
Joined March 27, 2017
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
GeertD's avatar
GeertD
New Member
3 years ago

This method seams rather convoluted to generate all possible Combinations, IMO.

Surely, there must be a simple way to generate all possible Combinations of n elements in k-size sequences.

(no repetition, so n>=k)

Also, I think we can restrict the study to just whole numbers.

(we can always have a dimension table at the side to translate those whole numbers to whtatever we want.)