- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
PERMUT function
Description
Returns the number of permutations for a given number of objects that can be selected from the number of objects. A permutation is any set or subset of objects or events where the internal order is significant.
Permutations are different from combinations, for which the internal order is not significant.
DAX PERMUT function is new in Excel 2016.
Syntax
PERMUT (<number>, <number_chosen>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
number A number that specifies the number of objects. |
2 |
number_chosen A number that specifies the number of objects in each permutation. |
Return Value
A whole number.
Remarks
You can use this function for lottery-style probability calculations.
Both parameters are truncated to integers.
If the number or number_chosen is non-numeric, PERMUT returns the #VALUE! error value.
If the number ≤ 0 or if number_chosen < 0, PERMUT returns the #NUM! error value.
If the number < number_chosen, PERMUT returns the #NUM! error value.
The equation for the number of permutations is −
$$P_{(k,\:n)}\:=\:\frac{n!}{(n\:-\:k)!}$$
Example
= PERMUT (8,3) returns 336. = PERMUT (9,2) returns 72.