Power Query
published
Search
⌃K

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.
Number.Combinations(5, 3)
10