Power BI is using a unified and scalable platform for self-service and enterprise business intelligence where DAX Functions (Data Analysis eXpressions) are used to compute Business Formulas. The most common DAX Functions are CALCULATE, CALCULATETABLE, SUM (All Aggregated), SUMX (Iterators), FILTER, FILTERS, RELATED, ALL, ALLEXCEPT, USERELATIONSHIP, SUMMARIZE, ADDCOLUMNS, DATESINPERIOD, GROUPBY, SELECTCOLUMN etc.
Please click here for Power BI details. If you are facing report optimization issues then please click here to learn power bi optimization techniques that can be applied to visualization, data model, ETL and Dax Functions layers.
Power BI DAX Functions are used in the following:
- Microsoft Power BI
- Microsoft Analysis Services
- Microsoft Power Pivot for Excel
DAX Data Types: Integer, Decimal, Currency, String, Boolean, Datetime, Variant and Binary.
DAX Operators: Parenthesis – () Arithmetic – +,–,*,/ Comparison – =,<>,<,>,<=,>= Text concatenation – & Logical – &&, ||, IN, NOT, AND, OR
Conditional Statements: IF, SWITCH
Following is the list of DAX Functions categories:
- Aggregated DAX Functions
- Date And Time DAX Functions
- Filter DAX Functions
- Financial DAX Functions
- Information DAX Functions
- Logical DAX Functions
- Math And Trig DAX Functions
- Other DAX Functions
- Parent And Child DAX Function
- Relationship DAX Functions
- Statistical DAX Functions
- Table Manipulation DAX Functions
- Text DAX Functions
- Time Intelligence DAX Functions
Aggregate Functions in Power BI DAX Functions
| Function | Formula | Description |
| APPROXIMATEDISTINCTCOUNT | APPROXIMATEDISTINCTCOUNT(<columnName>) | Returns the approximate number of rows that contain distinct values in a column. |
| AVERAGE | AVERAGE(<column>) | Returns the average (arithmetic mean) of all the numbers in a column. |
| AVERAGEA | AVERAGEA(<column>) | Returns the average (arithmetic mean) of the values in a column. |
| AVERAGEX | AVERAGEX(<table>,<expression>) | Calculates the average (arithmetic mean) of a set of expressions evaluated over a table. |
| COUNT | COUNT(<column>) | Counts the number of rows in the specified column that contain non-blank values. |
| COUNTA | COUNTA(<column>) | Counts the number of rows in the specified column that contain non-blank values. |
| COUNTAX | COUNTAX(<table>,<expression>) | Counts non-blank results when evaluating the result of an expression over a table. |
| COUNTBLANK | COUNTBLANK(<column>) | Counts the number of blank cells in a column. |
| COUNTROWS | COUNTROWS([<table>]) | Counts the number of rows in the specified table, or in a table defined by an expression. |
| COUNTX | COUNTX(<table>,<expression>) | Counts the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table. |
| DISTINCTCOUNT | DISTINCTCOUNT(<column>) | Counts the number of distinct values in a column. |
| DISTINCTCOUNTNOBLANK | DISTINCTCOUNTNOBLANK(<column>) | Counts the number of distinct values in a column. Unlike DISTINCTCOUNT function, DISTINCTCOUNTNOBLANK does not count the BLANK value. |
| MAX | MAX(<column>) | Returns the largest numeric value in a column, or between two scalar expressions. |
| MAXA | MAXA(<column>) | Returns the largest value in a column. |
| MAXX | MAXX(<table>,<expression>) | Evaluates an expression for each row of a table and returns the largest numeric value. |
| MIN | MIN(<column>) | Returns the smallest numeric value in a column, or between two scalar expressions. |
| MINA | MINA(<column>) | Returns the smallest value in a column, including any logical values and numbers represented as text. |
| MINX | MINX(<table>, < expression>) | Returns the smallest numeric value that results from evaluating an expression for each row of a table. |
| PRODUCT | PRODUCT(<column>) | Returns the product of the numbers in a column. |
| PRODUCTX | PRODUCTX(<table>, <expression>) | Returns the product of an expression evaluated for each row in a table. |
| SUM | SUM(<column>) | Adds all the numbers in a column. |
| SUMX | SUMX(<table>, <expression>) | Returns the sum of an expression evaluated for each row in a table. |
Date & Time Functions
| Function | Formula | Description |
| CALENDAR | CALENDAR(<start_date>, <end_date>) | Returns a table with a single column named “Date” that contains a contiguous set of dates. |
| CALENDARAUTO | CALENDARAUTO([fiscal_year_end_month]) | Returns a table with a single column named “Date” that contains a contiguous set of dates. |
| DATE | DATE(<year>, <month>, <day>) | Returns the specified date in datetime format. |
| DATEDIFF | DATEDIFF(<Date1>, <Date2>, <Interval>) | Returns the number of interval boundaries between two dates. |
| DATEVALUE | DATEVALUE(date_text) | Converts a date in the form of text to a date in datetime format. |
| DAY | DAY(<date>) | Returns the day of the month, a number from 1 to 31. |
| EDATE | EDATE(<start_date>, <months>) | Returns the date that is the indicated number of months before or after the start date. |
| EOMONTH | EOMONTH(<start_date>, <months>) | Returns the date in datetime format of the last day of the month, before or after a specified number of months. |
| HOUR | HOUR(<datetime>) | Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). |
| MINUTE | MINUTE(<datetime>) | Returns the minute as a number from 0 to 59, given a date and time value. |
| MONTH | MONTH(<datetime>) | Returns the month as a number from 1 (January) to 12 (December). |
| NETWORKDAYS | NETWORKDAYS(<start_date>, <end_date>[, <weekend>, <holidays>]) | Returns the number of whole workdays between two dates. |
| NOW | NOW() | Returns the current date and time in datetime format. |
| QUARTER | QUARTER(<date>) | Returns the quarter as a number from 1 to 4. |
| SECOND | SECOND(<time>) | Returns the seconds of a time value, as a number from 0 to 59. |
| TIME | TIME(hour, minute, second) | Converts hours, minutes, and seconds given as numbers to a time in datetime format. |
| TIMEVALUE | TIMEVALUE(time_text) | Converts a time in text format to a time in datetime format. |
| TODAY | TODAY() | Returns the current date. |
| UTCNOW | UTCNOW() | Returns the current UTC date and time |
| UTCTODAY | UTCTODAY() | Returns the current UTC date. |
| WEEKDAY | WEEKDAY(<date>, <return_type>) | Returns a number from 1 to 7 identifying the day of the week of a date. |
| WEEKNUM | WEEKNUM(<date>[, <return_type>]) | Returns the week number for the given date and year according to the return_type value. |
| YEAR | YEAR(<date>) | Returns the year of a date as a four digit integer in the range 1900-9999. |
| YEARFRAC | YEARFRAC(<start_date>, <end_date>, <basis>) | Calculates the fraction of the year represented by the number of whole days between two dates. |
Filter DAX Functions
| Function | Formula | Description |
| ALL | ALL( [<table> | <column>[, <column>[, <column>[,…]]]] ) | Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. |
| ALLCROSSFILTERED | ALLCROSSFILTERED(<table>) | Clear all filters which are applied to a table. |
| ALLEXCEPT | ALLEXCEPT(<table>,<column>[,<column>[,…]]) | Removes all context filters in the table except filters that have been applied to the specified columns. |
| ALLNOBLANKROW | ALLNOBLANKROW( {<table> | <column>[, <column>[, <column>[,…]]]} ) | From the parent table of a relationship, returns all rows but the blank row, or all distinct values of a column but the blank row, and disregards any context filters that might exist. |
| ALLSELECTED | ALLSELECTED([<tableName> | <columnName>[, <columnName>[, <columnName>[,…]]]] ) | Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters. |
| CALCULATE | CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]]) | Evaluates an expression in a modified filter context. |
| CALCULATETABLE | CALCULATETABLE(<expression>[, <filter1> [, <filter2> [, …]]]) | Evaluates a table expression in a modified filter context. |
| EARLIER | EARLIER(<column>, <number>) | Returns the current value of the specified column in an outer evaluation pass of the mentioned column. |
| EARLIEST | EARLIEST(<column>) | Returns the current value of the specified column in an outer evaluation pass of the specified column. |
| FILTER | FILTER(<table>,<filter>) | Returns a table that represents a subset of another table or expression. |
| KEEPFILTERS | KEEPFILTERS(<expression>) | Modifies how filters are applied while evaluating a CALCULATE or CALCULATETABLE function. |
| LOOKUPVALUE | LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value> [, <search2_columnName>, <search2_value>]… [, <alternateResult>] ) | Returns the value for the row that meets all criteria specified by search conditions. The function can apply one or more search conditions. |
| REMOVEFILTERS | REMOVEFILTERS([<table> | <column>[, <column>[, <column>[,…]]]]) | Clears filters from the specified tables or columns. |
| SELECTEDVALUE | SELECTEDVALUE(<columnName>[, <alternateResult>]) | Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult. |
Financial DAX Functions
| Function | Formula | Description |
| ACCRINT | ACCRINT(<issue>, <first_interest>, <settlement>, <rate>, <par>, <frequency>[, <basis>[, <calc_method>]]) | Returns the accrued interest for a security that pays periodic interest. |
| ACCRINTM | ACCRINTM(<issue>, <maturity>, <rate>, <par>[, <basis>]) | Returns the accrued interest for a security that pays interest at maturity. |
| AMORDEGRC | AMORDEGRC(<cost>, <date_purchased>, <first_period>, <salvage>, <period>, <rate>[, <basis>]) | Returns the depreciation for each accounting period. Similar to AMORLINC, except a depreciation coefficient is applied depending on the life of the assets. |
| AMORLINC | AMORLINC(<cost>, <date_purchased>, <first_period>, <salvage>, <period>, <rate>[, <basis>]) | Returns the depreciation for each accounting period. |
| COUPDAYBS | COUPDAYBS(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the number of days from the beginning of a coupon period until its settlement date. |
| COUPDAYS | COUPDAYS(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the number of days in the coupon period that contains the settlement date. |
| COUPDAYSNC | COUPDAYSNC(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the number of days from the settlement date to the next coupon date. |
| COUPNCD | COUPNCD(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the next coupon date after the settlement date. |
| COUPNUM | COUPNUM(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. |
| COUPPCD | COUPPCD(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the previous coupon date before the settlement date. |
| CUMIPMT | CUMIPMT(<rate>, <nper>, <pv>, <start_period>, <end_period>, <type>) | Returns the cumulative interest paid on a loan between start_period and end_period. |
| CUMPRINC | CUMPRINC(<rate>, <nper>, <pv>, <start_period>, <end_period>, <type>) | Returns the cumulative principal paid on a loan between start_period and end_period. |
| DB | DB(<cost>, <salvage>, <life>, <period>[, <month>]) | Returns the depreciation of an asset for a specified period using the fixed-declining balance method. |
| DDB | DDB(<cost>, <salvage>, <life>, <period>[, <factor>]) | Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. |
| DISC | DISC(<settlement>, <maturity>, <pr>, <redemption>[, <basis>]) | Returns the discount rate for a security. |
| DOLLARDE | DOLLARDE(<fractional_dollar>, <fraction>) | Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. |
| DOLLARFR | DOLLARFR(<decimal_dollar>, <fraction>) | Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. |
| DURATION | DURATION(<settlement>, <maturity>, <coupon>, <yld>, <frequency>[, <basis>]) | Returns the Macauley duration for an assumed par value of $100. |
| EFFECT | EFFECT(<nominal_rate>, <npery>) | Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. |
| FV | FV(<rate>, <nper>, <pmt>[, <pv>[, <type>]]) | Calculates the future value of an investment based on a constant interest rate. |
| INTRATE | INTRATE(<settlement>, <maturity>, <investment>, <redemption>[, <basis>]) | Returns the interest rate for a fully invested security. |
| IPMT | IPMT(<rate>, <per>, <nper>, <pv>[, <fv>[, <type>]]) | Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. |
| ISPMT | ISPMT(<rate>, <per>, <nper>, <pv>) | Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments. |
| MDURATION | MDURATION(<settlement>, <maturity>, <coupon>, <yld>, <frequency>[, <basis>]) | Returns the modified Macauley duration for a security with an assumed par value of $100. |
| NOMINAL | NOMINAL(<effect_rate>, <npery>) | Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year. |
| NPER | NPER(<rate>, <pmt>, <pv>[, <fv>[, <type>]]) | Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |
| ODDFPRICE | ODDFPRICE(<settlement>, <maturity>, <issue>, <first_coupon>, <rate>, <yld>, <redemption>, <frequency>[, <basis>]) | Returns the price per $100 face value of a security having an odd (short or long) first period. |
| ODDFYIELD | ODDFYIELD(<settlement>, <maturity>, <issue>, <first_coupon>, <rate>, <pr>, <redemption>, <frequency>[, <basis>]) | Returns the yield of a security that has an odd (short or long) first period. |
| ODDLPRICE | ODDLPRICE(<settlement>, <maturity>, <last_interest>, <rate>, <yld>, <redemption>, <frequency>[, <basis>]) | Returns the price per $100 face value of a security having an odd (short or long) last coupon period. |
| ODDLYIELD | ODDLYIELD(<settlement>, <maturity>, <last_interest>, <rate>, <pr>, <redemption>, <frequency>[, <basis>]) | Returns the yield of a security that has an odd (short or long) last period. |
| PDURATION | PDURATION(<rate>, <pv>, <fv>) | Returns the number of periods required by an investment to reach a specified value. |
| PMT | PMT(<rate>, <nper>, <pv>[, <fv>[, <type>]]) | Calculates the payment for a loan based on constant payments and a constant interest rate. |
| PPMT | PPMT(<rate>, <per>, <nper>, <pv>[, <fv>[, <type>]]) | Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. |
| PRICE | PRICE(<settlement>, <maturity>, <rate>, <yld>, <redemption>, <frequency>[, <basis>]) | Returns the price per $100 face value of a security that pays periodic interest. |
| PRICEDISC | PRICEDISC(<settlement>, <maturity>, <discount>, <redemption>[, <basis>]) | Returns the price per $100 face value of a discounted security. |
| PRICEMAT | PRICEMAT(<settlement>, <maturity>, <issue>, <rate>, <yld>[, <basis>]) | Returns the price per $100 face value of a security that pays interest at maturity. |
| PV | PV(<rate>, <nper>, <pmt>[, <fv>[, <type>]]) | Calculates the present value of a loan or an investment, based on a constant interest rate. |
| RATE | RATE(<nper>, <pmt>, <pv>[, <fv>[, <type>[, <guess>]]]) | Returns the interest rate per period of an annuity. |
| RECEIVED | RECEIVED(<settlement>, <maturity>, <investment>, <discount>[, <basis>]) | Returns the amount received at maturity for a fully invested security. |
| RRI | RRI(<nper>, <pv>, <fv>) | Returns an equivalent interest rate for the growth of an investment. |
| SLN | SLN(<cost>, <salvage>, <life>) | Returns the straight-line depreciation of an asset for one period. |
| SYD | SYD(<cost>, <salvage>, <life>, <per>) | Returns the sum-of-years’ digits depreciation of an asset for a specified period. |
| TBILLEQ | TBILLEQ(<settlement>, <maturity>, <discount>) | Returns the bond-equivalent yield for a Treasury bill. |
| TBILLPRICE | TBILLPRICE(<settlement>, <maturity>, <discount>) | Returns the price per $100 face value for a Treasury bill. |
| TBILLYIELD | TBILLYIELD(<settlement>, <maturity>, <pr>) | Returns the yield for a Treasury bill. |
| VDB | VDB(<cost>, <salvage>, <life>, <start_period>, <end_period>[, <factor>[, <no_switch>]]) | Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. |
| XIRR | XIRR(<table>, <values>, <dates>, [, <guess>[, <alternateResult>]]) | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. |
| XNPV | XNPV(<table>, <values>, <dates>, <rate>) | Returns the present value for a schedule of cash flows that is not necessarily periodic. |
| YIELD | YIELD(<settlement>, <maturity>, <rate>, <pr>, <redemption>, <frequency>[, <basis>]) | Returns the yield on a security that pays periodic interest. |
| YIELDDISC | YIELDDISC(<settlement>, <maturity>, <pr>, <redemption>[, <basis>]) | Returns the annual yield for a discounted security. |
| YIELDMAT | YIELDMAT(<settlement>, <maturity>, <issue>, <rate>, <pr>[, <basis>]) | Returns the annual yield of a security that pays interest at maturity. |
Information Functions
| Function | Formula | Description |
| CONTAINS | CONTAINS(<table>, <columnName>, <value>[, <columnName>, <value>]…) | Returns true if values for all referred columns exist, or are contained, in those columns; otherwise, the function returns false. |
| CONTAINSROW | CONTAINSROW(<Table>, <Value> [, <Value> [, …] ] ) | Returns TRUE if a row of values exists or contained in a table, otherwise returns FALSE. |
| CONTAINSSTRING | CONTAINSSTRING(<within_text>, <find_text>) | Returns TRUE or FALSE indicating whether one string contains another string. |
| CONTAINSSTRINGEXACT | CONTAINSSTRINGEXACT(<within_text>, <find_text>) | Returns TRUE or FALSE indicating whether one string contains another string. |
| CUSTOMDATA | CUSTOMDATA() | Returns the content of the CustomData property in the connection string. |
| HASONEFILTER | HASONEFILTER(<columnName>) | Returns TRUE when the number of directly filtered values on columnName is one; otherwise returns FALSE. |
| HASONEVALUE | HASONEVALUE(<columnName>) | Returns TRUE when the context for columnName has been filtered down to one distinct value only. Otherwise is FALSE. |
| ISAFTER | ISAFTER(<scalar_expression>, <scalar_expression>[, sort_order [, <scalar_expression>, <scalar_expression>[, sort_order]]…) | A boolean function that emulates the behavior of a Start At clause and returns true for a row that meets all of the condition parameters. |
| ISBLANK | ISBLANK(<value>) | Checks whether a value is blank, and returns TRUE or FALSE. |
| ISCROSSFILTERED | ISCROSSFILTERED(<TableNameOrColumnName>) | Returns TRUE when columnName or another column in the same or related table is being filtered. |
| ISEMPTY | ISEMPTY(<table_expression>) | Checks if a table is empty. |
| ISERROR | ISERROR(<value>) | Checks whether a value is an error, and returns TRUE or FALSE. |
| ISEVEN | ISEVEN(number) | Returns TRUE if number is even, or FALSE if number is odd. |
| ISFILTERED | ISFILTERED(<TableNameOrColumnName>) | Returns TRUE when columnName is being filtered directly. |
| ISINSCOPE | ISINSCOPE(<columnName>) | Returns true when the specified column is the level in a hierarchy of levels. |
| ISLOGICAL | ISLOGICAL(<value>) | Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE. |
| ISNONTEXT | ISNONTEXT(<value>) | Checks if a value is not text (blank cells are not text), and returns TRUE or FALSE. |
| ISNUMBER | ISNUMBER(<value>) | Checks whether a value is a number, and returns TRUE or FALSE. |
| ISODD | ISODD(number) | Returns TRUE if number is odd, or FALSE if number is even. |
| ISONORAFTER | ISONORAFTER(<scalar_expression>, <scalar_expression>[, sort_order [, <scalar_expression>, <scalar_expression>[, sort_order]]…) | A boolean function that emulates the behavior of a Start At clause and returns true for a row that meets all of the condition parameters. |
| ISSELECTEDMEASURE | ISSELECTEDMEASURE( M1, M2, … ) | Used by expressions for calculation items to determine the measure that is in context is one of those specified in a list of measures. |
| ISSUBTOTAL | ISSUBTOTAL(<columnName>) | Creates another column in a SUMMARIZE expression that returns True if the row contains subtotal values for the column given as argument, otherwise returns False. |
| ISTEXT | ISTEXT(<value>) | Checks if a value is text, and returns TRUE or FALSE. |
| NONVISUAL | NONVISUAL(<expression>) | Marks a value filter in a SUMMARIZECOLUMNS expression as non-visual. |
| SELECTEDMEASURE | SELECTEDMEASURE() | Used by expressions for calculation items to reference the measure that is in context. |
| SELECTEDMEASUREFORMATSTRING | SELECTEDMEASUREFORMATSTRING() | Used by expressions for calculation items to retrieve the format string of the measure that is in context. |
| SELECTEDMEASURENAME | SELECTEDMEASURENAME() | Used by expressions for calculation items to determine the measure that is in context by name. |
| USERNAME | USERNAME() | Returns the domain name and username from the credentials given to the system at connection time. |
| USEROBJECTID | USEROBJECTID() | Returns the current user’s Object ID or SID. |
| USERPRINCIPALNAME | USERPRINCIPALNAME() | Returns the user principal name. |
Logical Function
| Function | Formula | Description |
AND | AND(<logical1>,<logical2>) | Checks whether both arguments are TRUE, and returns TRUE if both arguments are TRUE. |
BITAND | BITAND(<number>, <number>) | Returns a bitwise ‘AND’ of two numbers. |
BITLSHIFT | BITLSHIFT(<Number>, <Shift_Amount>) | Returns a number shifted left by the specified number of bits. |
BITOR | BITOR(<number>, <number>) | Returns a bitwise ‘OR’ of two numbers. |
BITRSHIFT | BITRSHIFT(<Number>, <Shift_Amount>) | Returns a number shifted right by the specified number of bits. |
BITXOR | BITXOR(<number>, <number>) | Returns a bitwise ‘XOR’ of two numbers. |
COALESCE | COALESCE(<expression>, <expression>[, <expression>]…) | Returns the first expression that does not evaluate to BLANK. |
FALSE | FALSE() | Returns the logical value FALSE. |
IF | IF(<logical_test>, <value_if_true>[, <value_if_false>]) | Checks a condition, and returns one value when TRUE, otherwise it returns a second value. |
IF.EAGER | IF.EAGER(<logical_test>, <value_if_true>[, <value_if_false>]) | Checks a condition, and returns one value when TRUE, otherwise it returns a second value. Uses an eager execution plan which always executes the branch expressions regardless of the condition expression. |
IFERROR | IFERROR(value, value_if_error) | Evaluates an expression and returns a specified value if the expression returns an error |
NOT | NOT(<logical>) | Changes FALSE to TRUE, or TRUE to FALSE. |
OR | OR(<logical1>,<logical2>) | Checks whether one of the arguments is TRUE to return TRUE. |
SWITCH | SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>]) | Evaluates an expression against a list of values and returns one of multiple possible result expressions. |
TRUE | TRUE() | Returns the logical value TRUE. |
Math And Trig Function
| Function | Formula | Description |
ABS | ABS(<number>) | Returns the absolute value of a number. |
ACOS | ACOS(number) | Returns the arccosine, or inverse cosine, of a number. |
ACOSH | ACOSH(number) | Returns the inverse hyperbolic cosine of a number. |
ACOT | ACOT(number) | Returns the arccotangent, or inverse cotangent, of a number. |
ACOTH | ACOTH(number) | Returns the inverse hyperbolic cotangent of a number. |
ASIN | ASIN(number) | Returns the arcsine, or inverse sine, of a number. |
ASINH | ASINH(number) | Returns the inverse hyperbolic sine of a number. |
ATAN | ATAN(number) | Returns the arctangent, or inverse tangent, of a number. |
ATANH | ATANH(number) | Returns the inverse hyperbolic tangent of a number. |
CEILING | CEILING(<number>, <significance>) | Rounds a number up, to the nearest integer or to the nearest multiple of significance. |
CONVERT | CONVERT(<Expression>, <Datatype>) | Converts an expression of one data type to another. |
COS | COS(number) | Returns the cosine of the given angle. |
COSH | COSH(number) | Returns the hyperbolic cosine of a number. |
COT | COT (<number>) | Returns the cotangent of an angle specified in radians. |
COTH | COTH (<number>) | Returns the hyperbolic cotangent of a hyperbolic angle. |
CURRENCY | CURRENCY(<value>) | Evaluates the argument and returns the result as currency data type. |
DEGREES | DEGREES(angle) | Converts radians into degrees. |
DIVIDE | DIVIDE(<numerator>, <denominator> [,<alternateresult>]) | Performs division and returns alternate result or BLANK() on division by 0. |
EVEN | EVEN(number) | Returns number rounded up to the nearest even integer. |
EXP | EXP(<number>) | Returns e raised to the power of a given number. |
FACT | FACT(<number>) | Returns the factorial of a number, equal to the series 1*2*3*…* , ending in the given number. |
FLOOR | FLOOR(<number>, <significance>) | Rounds a number down, toward zero, to the nearest multiple of significance. |
GCD | GCD(number1, [number2], …) | Returns the greatest common divisor of two or more integers. |
INT | INT(<number>) | Rounds a number down to the nearest integer. |
ISO.CEILING | ISO.CEILING(<number>[, <significance>]) | Rounds a number up, to the nearest integer or to the nearest multiple of significance. |
LCM | LCM(number1, [number2], …) | Returns the least common multiple of integers. |
LN | LN(<number>) | Returns the natural logarithm of a number. |
LOG | LOG(<number>,<base>) | Returns the logarithm of a number to the base you specify. |
LOG10 | LOG10(<number>) | Returns the base-10 logarithm of a number. |
MOD | MOD(<number>, <divisor>) | Returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor. |
MROUND | MROUND(<number>, <multiple>) | Returns a number rounded to the desired multiple. |
ODD | ODD(number) | Returns number rounded up to the nearest odd integer. |
PI | PI() | Returns the value of Pi, 3.14159265358979, accurate to 15 digits. |
POWER | POWER(<number>, <power>) | Returns the result of a number raised to a power. |
QUOTIENT | QUOTIENT(<numerator>, <denominator>) | Performs division and returns only the integer portion of the division result. |
RADIANS | RADIANS(angle) | Converts degrees to radians. |
RAND | RAND() | Returns a random number greater than or equal to 0 and less than 1, evenly distributed. |
RANDBETWEEN | RANDBETWEEN(<bottom>,<top>) | Returns a random number in the range between two numbers you specify. |
ROUND | ROUND(<number>, <num_digits>) | Rounds a number to the specified number of digits. |
ROUNDDOWN | ROUNDDOWN(<number>, <num_digits>) | Rounds a number down, toward zero. |
ROUNDUP | ROUNDUP(<number>, <num_digits>) | Rounds a number up, away from 0 (zero). |
SIGN | SIGN(<number>) | Determines the sign of a number, the result of a calculation, or a value in a column. |
SIN | SIN(number) | Returns the sine of the given angle. |
SINH | SINH(number) | Returns the hyperbolic sine of a number. |
SQRT | SQRT(<number>) | Returns the square root of a number. |
SQRTPI | SQRTPI(number) | Returns the square root of (number * pi). |
TAN | TAN(number) | Returns the tangent of the given angle. |
TANH | TANH(number) | Returns the hyperbolic tangent of a number. |
TRUNC | TRUNC(<number>,<num_digits>) | Truncates a number to an integer by removing the decimal, or fractional, part of the number. |