Power BI DAX Functions | 14 Categories DAX’s with Syntax

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

FunctionFormulaDescription
APPROXIMATEDISTINCTCOUNTAPPROXIMATEDISTINCTCOUNT(<columnName>)Returns the approximate
 number of rows that contain distinct values in a column.
AVERAGEAVERAGE(<column>) Returns the average (arithmetic mean) of all the numbers in a column.
AVERAGEAAVERAGEA(<column>) Returns the average (arithmetic mean) of the values in a column.
AVERAGEXAVERAGEX(<table>,<expression>) Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.
COUNTCOUNT(<column>) Counts the number of rows in the specified column that contain non-blank values.
COUNTACOUNTA(<column>) Counts the number of rows in the specified column that contain non-blank values.
COUNTAXCOUNTAX(<table>,<expression>) Counts non-blank results when evaluating the result of an expression over a table.
COUNTBLANKCOUNTBLANK(<column>) Counts the number of blank cells in a column.
COUNTROWSCOUNTROWS([<table>]) Counts the number of rows in the specified table, or in a table defined by an expression.
COUNTXCOUNTX(<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.
DISTINCTCOUNTDISTINCTCOUNT(<column>)  Counts the number of distinct values in a column.
DISTINCTCOUNTNOBLANKDISTINCTCOUNTNOBLANK(<column>)  Counts the number of distinct values in a column. Unlike DISTINCTCOUNT function, DISTINCTCOUNTNOBLANK does not count the BLANK value.
MAXMAX(<column>) Returns the largest numeric value in a column, or between two scalar expressions.
MAXAMAXA(<column>)  Returns the largest value in a column.
MAXXMAXX(<table>,<expression>)  Evaluates an expression for each row of a table and returns the largest numeric value.
MINMIN(<column>)Returns the smallest numeric value in a column, or between two scalar expressions.
MINAMINA(<column>)  Returns the smallest value in a column, including any logical values and numbers represented as text.
MINXMINX(<table>, < expression>) Returns the smallest numeric value that results from evaluating an expression for each row of a table.
PRODUCTPRODUCT(<column>)  Returns the product of the numbers in a column.
PRODUCTXPRODUCTX(<table>, <expression>) Returns the product of an expression evaluated for each row in a table.
SUMSUM(<column>) Adds all the numbers in a column.
SUMXSUMX(<table>, <expression>)Returns the sum of an expression evaluated for each row in a table.

Date & Time Functions

FunctionFormulaDescription
CALENDARCALENDAR(<start_date>, <end_date>) Returns a table with a single column named “Date” that contains a contiguous set of dates.
CALENDARAUTOCALENDARAUTO([fiscal_year_end_month]) Returns a table with a single column named “Date” that contains a contiguous set of dates.
DATEDATE(<year>, <month>, <day>) Returns the specified date in datetime format.
DATEDIFFDATEDIFF(<Date1>, <Date2>, <Interval>) Returns the number of interval boundaries between two dates.
DATEVALUEDATEVALUE(date_text)  Converts a date in the form of text to a date in datetime format.
DAYDAY(<date>) Returns the day of the month, a number from 1 to 31.
EDATEEDATE(<start_date>, <months>) Returns the date that is the indicated number of months before or after the start date.
EOMONTHEOMONTH(<start_date>, <months>) Returns the date in datetime format of the last day of the month, before or after a specified number of months.
HOURHOUR(<datetime>)Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
MINUTEMINUTE(<datetime>)Returns the minute as a number from 0 to 59, given a date and time value.
MONTHMONTH(<datetime>)Returns the month as a number from 1 (January) to 12 (December).
NETWORKDAYSNETWORKDAYS(<start_date>, <end_date>[, <weekend>, <holidays>])Returns the number of whole workdays between two dates.
NOWNOW()Returns the current date and time in datetime format.
QUARTERQUARTER(<date>)Returns the quarter as a number from 1 to 4.
SECONDSECOND(<time>)Returns the seconds of a time value, as a number from 0 to 59.
TIMETIME(hour, minute, second)Converts hours, minutes, and seconds given as numbers to a time in datetime format.
TIMEVALUETIMEVALUE(time_text)Converts a time in text format to a time in datetime format.
TODAYTODAY()Returns the current date.
UTCNOWUTCNOW() Returns the current UTC date and time
UTCTODAYUTCTODAY()Returns the current UTC date.
WEEKDAYWEEKDAY(<date>, <return_type>)Returns a number from 1 to 7 identifying the day of the week of a date.
WEEKNUMWEEKNUM(<date>[, <return_type>])Returns the week number for the given date and year according to the return_type value.
YEARYEAR(<date>)Returns the year of a date as a four digit integer in the range 1900-9999.
YEARFRACYEARFRAC(<start_date>, <end_date>, <basis>)Calculates the fraction of the year represented by the number of whole days between two dates.

Filter DAX Functions

FunctionFormulaDescription
ALLALL( [<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.
ALLCROSSFILTEREDALLCROSSFILTERED(<table>)Clear all filters which are applied to a table.
ALLEXCEPTALLEXCEPT(<table>,<column>[,<column>[,…]])Removes all context filters in the table except filters that have been applied to the specified columns.
ALLNOBLANKROWALLNOBLANKROW( {<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.
ALLSELECTEDALLSELECTED([<tableName> | <columnName>[, <columnName>[, <columnName>[,…]]]] )Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.
CALCULATECALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])Evaluates an expression in a modified filter context.
CALCULATETABLECALCULATETABLE(<expression>[, <filter1> [, <filter2> [, …]]])Evaluates a table expression in a modified filter context.
EARLIEREARLIER(<column>, <number>)Returns the current value of the specified column in an outer evaluation pass of the mentioned column.
EARLIESTEARLIEST(<column>)Returns the current value of the specified column in an outer evaluation pass of the specified column.
FILTERFILTER(<table>,<filter>)Returns a table that represents a subset of another table or expression.
KEEPFILTERSKEEPFILTERS(<expression>)Modifies how filters are applied while evaluating a CALCULATE or CALCULATETABLE function.
LOOKUPVALUELOOKUPVALUE(     <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.
REMOVEFILTERSREMOVEFILTERS([<table> | <column>[, <column>[, <column>[,…]]]])Clears filters from the specified tables or columns.
SELECTEDVALUESELECTEDVALUE(<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

FunctionFormulaDescription
ACCRINTACCRINT(<issue>, <first_interest>, <settlement>, <rate>, <par>, <frequency>[, <basis>[, <calc_method>]])Returns the accrued interest for a security that pays periodic interest.
ACCRINTMACCRINTM(<issue>, <maturity>, <rate>, <par>[, <basis>])Returns the accrued interest for a security that pays interest at maturity.
AMORDEGRCAMORDEGRC(<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.
AMORLINCAMORLINC(<cost>, <date_purchased>, <first_period>, <salvage>, <period>, <rate>[, <basis>])Returns the depreciation for each accounting period.
COUPDAYBSCOUPDAYBS(<settlement>, <maturity>, <frequency>[, <basis>])Returns the number of days from the beginning of a coupon period until its settlement date.
COUPDAYSCOUPDAYS(<settlement>, <maturity>, <frequency>[, <basis>])Returns the number of days in the coupon period that contains the settlement date.
COUPDAYSNCCOUPDAYSNC(<settlement>, <maturity>, <frequency>[, <basis>])Returns the number of days from the settlement date to the next coupon date.
COUPNCDCOUPNCD(<settlement>, <maturity>, <frequency>[, <basis>])Returns the next coupon date after the settlement date.
COUPNUMCOUPNUM(<settlement>, <maturity>, <frequency>[, <basis>])Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
COUPPCDCOUPPCD(<settlement>, <maturity>, <frequency>[, <basis>])Returns the previous coupon date before the settlement date.
CUMIPMTCUMIPMT(<rate>, <nper>, <pv>, <start_period>, <end_period>, <type>)Returns the cumulative interest paid on a loan between start_period and end_period.
CUMPRINCCUMPRINC(<rate>, <nper>, <pv>, <start_period>, <end_period>, <type>)Returns the cumulative principal paid on a loan between start_period and end_period.
DBDB(<cost>, <salvage>, <life>, <period>[, <month>])Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
DDBDDB(<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.
DISCDISC(<settlement>, <maturity>, <pr>, <redemption>[, <basis>])Returns the discount rate for a security.
DOLLARDEDOLLARDE(<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.
DOLLARFRDOLLARFR(<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.
DURATIONDURATION(<settlement>, <maturity>, <coupon>, <yld>, <frequency>[, <basis>])Returns the Macauley duration for an assumed par value of $100.
EFFECTEFFECT(<nominal_rate>, <npery>)Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
FVFV(<rate>, <nper>, <pmt>[, <pv>[, <type>]])Calculates the future value of an investment based on a constant interest rate.
INTRATEINTRATE(<settlement>, <maturity>, <investment>, <redemption>[, <basis>])Returns the interest rate for a fully invested security.
IPMTIPMT(<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.
ISPMTISPMT(<rate>, <per>, <nper>, <pv>)Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments.
MDURATIONMDURATION(<settlement>, <maturity>, <coupon>, <yld>, <frequency>[, <basis>])Returns the modified Macauley duration for a security with an assumed par value of $100.
NOMINALNOMINAL(<effect_rate>, <npery>)Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
NPERNPER(<rate>, <pmt>, <pv>[, <fv>[, <type>]])Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
ODDFPRICEODDFPRICE(<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.
ODDFYIELDODDFYIELD(<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.
ODDLPRICEODDLPRICE(<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.
ODDLYIELDODDLYIELD(<settlement>, <maturity>, <last_interest>, <rate>, <pr>, <redemption>, <frequency>[, <basis>])Returns the yield of a security that has an odd (short or long) last period.
PDURATIONPDURATION(<rate>, <pv>, <fv>)Returns the number of periods required by an investment to reach a specified value.
PMTPMT(<rate>, <nper>, <pv>[, <fv>[, <type>]])Calculates the payment for a loan based on constant payments and a constant interest rate.
PPMTPPMT(<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.
PRICEPRICE(<settlement>, <maturity>, <rate>, <yld>, <redemption>, <frequency>[, <basis>])Returns the price per $100 face value of a security that pays periodic interest.
PRICEDISCPRICEDISC(<settlement>, <maturity>, <discount>, <redemption>[, <basis>])Returns the price per $100 face value of a discounted security.
PRICEMATPRICEMAT(<settlement>, <maturity>, <issue>, <rate>, <yld>[, <basis>])Returns the price per $100 face value of a security that pays interest at maturity.
PVPV(<rate>, <nper>, <pmt>[, <fv>[, <type>]])Calculates the present value of a loan or an investment, based on a constant interest rate.
RATERATE(<nper>, <pmt>, <pv>[, <fv>[, <type>[, <guess>]]])Returns the interest rate per period of an annuity.
RECEIVEDRECEIVED(<settlement>, <maturity>, <investment>, <discount>[, <basis>])Returns the amount received at maturity for a fully invested security.
RRIRRI(<nper>, <pv>, <fv>)Returns an equivalent interest rate for the growth of an investment.
SLNSLN(<cost>, <salvage>, <life>)Returns the straight-line depreciation of an asset for one period.
SYDSYD(<cost>, <salvage>, <life>, <per>)Returns the sum-of-years’ digits depreciation of an asset for a specified period.
TBILLEQTBILLEQ(<settlement>, <maturity>, <discount>)Returns the bond-equivalent yield for a Treasury bill.
TBILLPRICETBILLPRICE(<settlement>, <maturity>, <discount>)Returns the price per $100 face value for a Treasury bill.
TBILLYIELDTBILLYIELD(<settlement>, <maturity>, <pr>)Returns the yield for a Treasury bill.
VDBVDB(<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.
XIRRXIRR(<table>, <values>, <dates>, [, <guess>[, <alternateResult>]]) Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
XNPVXNPV(<table>, <values>, <dates>, <rate>)Returns the present value for a schedule of cash flows that is not necessarily periodic.
YIELDYIELD(<settlement>, <maturity>, <rate>, <pr>, <redemption>, <frequency>[, <basis>])Returns the yield on a security that pays periodic interest.
YIELDDISCYIELDDISC(<settlement>, <maturity>, <pr>, <redemption>[, <basis>])Returns the annual yield for a discounted security.
YIELDMATYIELDMAT(<settlement>, <maturity>, <issue>, <rate>, <pr>[, <basis>])Returns the annual yield of a security that pays interest at maturity.

Information Functions

FunctionFormulaDescription
CONTAINSCONTAINS(<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.
CONTAINSROWCONTAINSROW(<Table>, <Value> [, <Value> [, …] ] ) Returns TRUE if a row of values exists or contained in a table, otherwise returns FALSE.
CONTAINSSTRINGCONTAINSSTRING(<within_text>, <find_text>)Returns TRUE or FALSE indicating whether one string contains another string.
CONTAINSSTRINGEXACTCONTAINSSTRINGEXACT(<within_text>, <find_text>)Returns TRUE or FALSE indicating whether one string contains another string.
CUSTOMDATACUSTOMDATA()Returns the content of the CustomData property in the connection string.
HASONEFILTERHASONEFILTER(<columnName>)Returns TRUE when the number of directly filtered values on 
columnName
 is one; otherwise returns FALSE.
HASONEVALUEHASONEVALUE(<columnName>)Returns TRUE when the context for 
columnName
 has been filtered down to one distinct value only. Otherwise is FALSE.
ISAFTERISAFTER(<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.
ISBLANKISBLANK(<value>)Checks whether a value is blank, and returns TRUE or FALSE.
ISCROSSFILTEREDISCROSSFILTERED(<TableNameOrColumnName>)Returns TRUE when 
columnName
 or another column in the same or related table is being filtered.
ISEMPTYISEMPTY(<table_expression>)Checks if a table is empty.
ISERRORISERROR(<value>)Checks whether a value is an error, and returns TRUE or FALSE.
ISEVENISEVEN(number)Returns TRUE if number is even, or FALSE if number is odd.
ISFILTEREDISFILTERED(<TableNameOrColumnName>)Returns TRUE when 
columnName
 is being filtered directly.
ISINSCOPEISINSCOPE(<columnName>)Returns true when the specified column is the level in a hierarchy of levels.
ISLOGICALISLOGICAL(<value>)Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.
ISNONTEXTISNONTEXT(<value>)Checks if a value is not text (blank cells are not text), and returns TRUE or FALSE.
ISNUMBERISNUMBER(<value>)Checks whether a value is a number, and returns TRUE or FALSE.
ISODDISODD(number)Returns TRUE if number is odd, or FALSE if number is even.
ISONORAFTERISONORAFTER(<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.
ISSELECTEDMEASUREISSELECTEDMEASURE( 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.
ISSUBTOTALISSUBTOTAL(<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.
ISTEXTISTEXT(<value>)Checks if a value is text, and returns TRUE or FALSE.
NONVISUALNONVISUAL(<expression>)Marks a value filter in a SUMMARIZECOLUMNS expression as non-visual.
SELECTEDMEASURESELECTEDMEASURE()Used by expressions for calculation items to reference the measure that is in context.
SELECTEDMEASUREFORMATSTRINGSELECTEDMEASUREFORMATSTRING()Used by expressions for calculation items to retrieve the format string of the measure that is in context.
SELECTEDMEASURENAMESELECTEDMEASURENAME()Used by expressions for calculation items to determine the measure that is in context by name.
USERNAMEUSERNAME()Returns the domain name and username from the credentials given to the system at connection time.
USEROBJECTIDUSEROBJECTID()Returns the current user’s Object ID or SID.
USERPRINCIPALNAMEUSERPRINCIPALNAME()Returns the user principal name.

Logical Function

FunctionFormulaDescription

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

FunctionFormula 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.

Leave a Reply

Your email address will not be published. Required fields are marked *