COMBINA
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Returns the number of combinations (with repetitions) for a given number of items.
Syntax
COMBINA(number, number_chosen)
Parameters
Term | Definition |
---|---|
number | Must be greater than or equal to 0, and greater than or equal to Number_chosen. Non-integer values are truncated. |
number_chosen | Must be greater than or equal to 0. Non-integer values are truncated. |
Return value
Returns the number of combinations (with repetitions) for a given number of items.
Remarks
If the value of either argument is outside of its constraints, COMBINA returns the #NUM! error value.
If either argument is a non-numeric value, COMBINA returns the #VALUE! error value.
The following equation is used, where $N$ is Number and $M$ is Number_chosen:
$${N+M-1 \choose N-1}$$
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
Formula | Description | Result |
---|---|---|
= COMBINA(4,3) | Returns the number of combinations (with repetitions) for 4 and 3. | 20 |
= COMBINA(10,3) | Returns the number of combinations (with repetitions) for 10 and 3. | 220 |
Tagasiside
https://aka.ms/ContentUserFeedback.
Varsti tulekul: 2024. aasta jooksul tühistame GitHubi probleemide funktsiooni sisutagasiside mehhanismina ja asendame selle uue tagasisidesüsteemiga. Lisateabe saamiseks vtEsita ja vaata tagasisidet