Number.Combinations

This function calculates the total number of distinct combinations that can be generated from a given list of items. It takes two parameters: setSize, which represents the total number of items in the...

Syntax

Number.Combinations(setSize as nullable number, combinationSize as nullable number) as nullable number

About

This function calculates the total number of distinct combinations that can be generated from a given list of items. It takes two parameters: setSize, which represents the total number of items in the list, and combinationSize, which indicates the number of items in each combination.

Explanation

Determine the number of possible combinations when selecting 3 items out of a total of 5. Use the Power Query MNumber.Combinations(5, 3) function to calculate. The output will be 10 combinations.