QUOTIENT
A
C
- CALCULATE
- CALCULATETABLE
- CALENDAR
- CALENDARAUTO
- CEILING
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- COALESCE
- COLUMNSTATISTICS
- COMBIN
- COMBINA
- COMBINEVALUES
- CONCATENATE
- CONCATENATEX
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONTAINS
- CONTAINSROW
- CONTAINSSTRING
- CONTAINSSTRINGEXACT
- CONVERT
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CROSSFILTER
- CROSSJOIN
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENTGROUP
- CUSTOMDATA
D
E
I
N
O
P
R
S
- SAMEPERIODLASTYEAR
- SAMPLE
- SEARCH
- SECOND
- SELECTCOLUMNS
- SELECTEDMEASURE
- SELECTEDMEASUREFORMATSTRING
- SELECTEDMEASURENAME
- SELECTEDVALUE
- SIGN
- SIN
- SINH
- SLN
- SQRT
- SQRTPI
- STARTOFMONTH
- STARTOFQUARTER
- STARTOFYEAR
- STDEVX.P
- STDEVX.S
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUBSTITUTEWITHINDEX
- SUM
- SUMMARIZE
- SUMMARIZECOLUMNS
- SUMX
- SWITCH
- SYD
T
U
Syntax of QUOTIENT Function
The syntax of the QUOTIENT function is as follows:
QUOTIENT(numerator, denominator)
Where,
- **numerator:** This is a required argument and represents the value to be divided.
- **denominator:** This is also a required argument and represents the value by which the numerator is divided.
Example Usage of QUOTIENT Function
Let's understand the usage of QUOTIENT function with the help of an example. Suppose, we have the following data:
| Value 1 | Value 2 |
| --- | --- |
| 10 | 3 |
| 15 | 4 |
| 20 | 5 |
To calculate the integer portion of the division operation between Value 1 and Value 2, we can use the following DAX formula:
QUOTIENT([Value 1], [Value 2])
This will return the following output:
| Output |
| --- |
| 3 |
| 3 |
| 4 |
Using QUOTIENT Function with Rounding
In some cases, we may need to round the result of the QUOTIENT function to the nearest whole number. For example, if we have the following data:
| Value 1 | Value 2 |
| --- | --- |
| 10 | 3 |
| 15 | 4 |
| 20 | 5 |
| 2 | 3 |
To calculate the integer portion of the division operation and round it to the nearest whole number, we can use the following DAX formula:
ROUND(QUOTIENT([Value 1], [Value 2]),0)
This will return the following output:
| Output |
| --- |
| 3 |
| 4 |
| 4 |
| 1 |
Using QUOTIENT Function with IF Statement
In some cases, we may need to use the QUOTIENT function in conjunction with an IF statement to perform conditional calculations. For example, if we have the following data:
| Value 1 | Value 2 |
| --- | --- |
| 10 | 3 |
| 15 | 4 |
| 20 | 5 |
| 2 | 3 |
To calculate the integer portion of the division operation only for those records where Value 2 is greater than 3, we can use the following DAX formula:
IF([Value 2] ❱ 3, QUOTIENT([Value 1], [Value 2]), BLANK())
This will return the following output:
| Output |
| --- |
| 3 |
| 4 |
| 4 |
| BLANK |
The QUOTIENT function is a simple yet powerful function available in Power BI. It can be used to perform integer division operations, round the result to the nearest whole number, or perform conditional calculations using IF statement. By understanding the syntax and usage of QUOTIENT function, you can improve your data analysis and reporting capabilities in Power BI.
