Power Query
Search…
Number.Combinations

Number.Combinations

Returns the number of unique combinations.
function (optional setSize as nullable any, optional combinationSize as nullable any) as nullable any

Description

Returns the number of unique combinations from a list of items, setSize with specified combination size, combinationSize.

Category

Number.Operations

Examples

Find the number of combinations from a total of 5 items when each combination is a group of 3.
1
Number.Combinations(5, 3)
Copied!
10
Last modified 3yr ago