← Back to Number functions

Number.Permutations

Returns the total number of possible arrangements that can be created from a given set of items, setSize, of a specific size for each arrangement, permutationSize.

Syntax

Number.Permutations(setSize as nullable number, permutationSize as nullable number) as nullable number

About

Returns the total number of possible arrangements that can be created from a given set of items, setSize, of a specific size for each arrangement, permutationSize.

Explanation

Calculate the total number of possible arrangements that can be made from a set of 5 items taken in groups of 3 by using the Power Query MNumber.Permutations(5, 3) function. The result will be 60 permutations.