Business Formulas are calculated using DAX Functions (Data Analysis expressions), which are part of Power BI’s unified and scalable platform for self-service and enterprise business intelligence. ADDCOLUMNS, DATESINPERIOD, GROUPBY, SELECTCOLUMN, USERELATIONSHIP, SUMMARIZE, FILTER, FILTERS, RELATED, ALL, ALLEXCEPT, CALCULATE, CALCULATETABLE, SUM (All Aggregated), SUMX (Iterators), and so on are among the most frequently used DAX functions.
For additional information about power BI, click here. If you’re struggling to optimize your Powe BI reports, click here to explore techniques for improving visualization, data models, ETL, and DAX functions.
The following applications make use of Power BI DAX functions:
-
- Microsoft Analysis Services
- Microsoft Power BI
- Excel’s Microsoft Power Pivot
DAX Data Type:
Binary, Decimal, Currency, String, Boolean, Datetime, Variant, and Integer are the DAX data types.
DAX Operators:
The parenthesis – () Calculation – +,–,*,/ Comparison – =,<>,<,>,<=,>= Concatenation of text – & Logical – &&, ||, IN, NOT, AND, OR
Conditional Statements:
IF, SWITCH
The list of DAX Functions categories is as follows:
- 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
- Relationships DAX functions
- Statistical DAX functions
- Table manipulation DAX functions
- Text DAX functions
- Time intelligence DAX functions.
Aggregate Functions in Power BI DAX Functions
The following functions and formulas are available in Power BI:
| S.No. | Function | Formula | Description |
| 1. | APPROXIMATEDISTINCTCOUNT | APPROXIMATEDISTINCTCOUNT(<columnName>) | Returns an approximate count of distinct values in a column. |
| 2. | AVERAGE | AVERAGE(<column>) | Calculates the arithmetic mean of numbers in a column. |
| 3. | AVERAGEA (including non-numeric values) | AVERAGEA(<column>) | Returns the average of values in a column, including non-numeric values. |
| 4. | AVERAGEX (evaluated over a table) | AVERAGEX(<table>, <expression>) | Calculates the average of an expression evaluated for each row in a table. |
| 5. | COUNT | COUNT(<column>) | Counts non-blank values in a column. |
| 6. | COUNTA (including non-numeric values) | COUNTA(<column>) | Counts non-blank values in a column, including non-numeric values. |
| 7. | COUNTAX (evaluated over a table) | COUNTAX(<table>, <expression>) | Counts non-blank results of an expression evaluated for each row in a table. |
| 8. | COUNTBLANK | COUNTBLANK(<column>) | Counts blank cells in a column. |
| 9. | COUNTROWS | COUNTROWS([<table>]) | Counts rows in a table. |
| 10. | COUNTX (evaluated over a table) | COUNTX(<table>, <expression>) | Counts rows containing a number or an expression that evaluates to a number. |
| 11. | DISTINCTCOUNT | DISTINCTCOUNT(<column>) | Counts distinct values in a column. |
| 12. | DISTINCTCOUNTNOBLANK | DISTINCTCOUNTNOBLANK(<column>) | Counts distinct values in a column, excluding blanks. |
| 13. | MAX | MAX(<column>) | Returns the largest numeric value in a column. |
| 14. | MAXA (including non-numeric values) | MAXA(<column>) | Returns the largest value in a column. |
| 15. | MAXX (evaluated over a table) | MAXX(<table>, <expression>) | Evaluates an expression for each row in a table and returns the largest numeric value. |
| 16. | MIN | MIN(<column>) | Returns the smallest numeric value in a column. |
| 17. | MINA (including non-numeric values) | MINA(<column>) | Returns the smallest value in a column. |
| 18. | MINX (evaluated over a table): | MINX(<table>, <expression>) | Evaluates an expression for each row in a table and returns the smallest numeric value. |
| 19. | PRODUCT | PRODUCT(<column>) | Returns the product of numbers in a column. |
| 20. | PRODUCTX (evaluated over a table) | PRODUCTX(<table>, <expression>) | Returns the product of an expression evaluated for each row in a table. |
| 21. | SUM | SUM(<column>) | Adds all numbers in a column |
| 22. | SUMX (evaluated over a table) | SUMX(<table>, <expression>) | Returns the sum of an expression evaluated for each row in a table. |
Date & Time Functions
The following functions help you work with dates and times in Power BI:
| S.No. | Function | Formula | Description |
| 1. | CALENDAR | CALENDAR(<start_date>, <end_date>) | Generates a table with a contiguous set of dates between two specified dates. |
| 2. | CALENDARAUTO | CALENDARAUTO([fiscal_year_end_month]) | Automatically generates a table with a contiguous set of dates based on the fiscal year end month. |
| 3. | DATE | DATE(<year>, <month>, <day>) | Returns a specified date in datetime format. |
| 4. | DATEDIFF | DATEDIFF(<Date1>, <Date2>, <Interval>) | Calculates the number of intervals (days, months, etc.) between two dates. |
| 5. | DATEVALUE | DATEVALUE(date_text) | Converts a text date to a datetime format. |
| 6. | DAY | DAY(<date>) | Returns the day of the month (1-31) |
| 7. | EOMONTH | EOMONTH(<start_date>, <months>) | Returns the last day of the month, before or after a specified number of months |
| 8. | HOUR | HOUR(<datetime>) | Returns the hour (0-23) |
| 9. | MINUTE | MINUTE(<datetime>) | Returns the minute (0-59) |
| 10. | MONTH | MONTH(<datetime>) | Returns the month (1-12) |
| 11. | NETWORKDAYS | NETWORKDAYS(<start_date>, <end_date>[, <weekend>, <holidays>]) | Calculates the number of workdays between two dates |
| 12. | NOW | NOW () | Returns the current date and time |
| 13. | QUARTER | QUARTER(<date>) | Returns the quarter (1-4) |
| 14. | SECOND | SECOND(<time>) | Returns the seconds (0-59) |
| 15. | TIME | TIME (hour, minute, second) | Converts hours, minutes, and seconds to a time |
| 16. | TIMEVALUE | TIMEVALUE (time_text) | Converts a text time to a datetime format |
| 17. | TODAY | TODAY() | Returns the current date |
| 18. | UTCNOW | UTCNOW() | Returns the current UTC date and time |
| 19. | UTCTODAY | UTCTODAY() | Returns the current UTC date |
| 20. | WEEKDAY | WEEKDAY(<date>, <return_type>) | Returns the day of the week (1-7) |
| 21. | WEEKNUM | WEEKNUM(<date>[, <return_type>]) | Returns the week number |
| 22. | YEAR | YEAR(<date>) | Returns the year (1900-9999 |
| 23. | YEARFRAC | YEARFRAC(<start_date>, <end_date>, <basis>) | Calculates the fraction of the year between two dates |
DAX Filter Functions
The following functions help you work with filters in DAX:
| S.No. | Function | Formula | Description |
| 1. | ALL | ALL( [<table> | <column>[, <column>[, <column>[,…]]]] ) | Returns all rows in a table or all values in a column, ignoring filters |
| 2. | ALLCROSSFILTERED | ALLCROSSFILTERED(<table>) | Clears all filters applied to a table |
| 3. | ALLEXCEPT | ALLEXCEPT(<table>,<column>[,<column>[,…]]) | Removes all context filters except those applied to specified columns |
| 4. | ALLNOBLANKROW | ALLNOBLANKROW( {<table> | <column>[, <column>[, <column>[,…]]]} ) | Returns all rows or distinct values, excluding blank rows, and disregards context filters |
| 5. | ALLSELECTED | ALLSELECTED([<tableName> | <columnName>[, <columnName>[, <columnName>[,…]]]] ) | Removes context filters while retaining other filters |
| 6. | CALCULATE | CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]]) – | Evaluates an expression in a modified filter context. |
| 7. | CALCULATETABLE | CALCULATETABLE(<expression>[, <filter1> [, <filter2> [, …]]]) -. | Evaluates a table expression in a modified filter context |
| 8. | EARLIER | EARLIER(<column>, <number>) | Returns the current value of a column in an outer evaluation pass. |
| 9. | EARLIEST | EARLIEST(<column>) | Returns the current value of a column in an outer evaluation pass. |
| 10. | FILTER | FILTER(<table>,<filter>) | Returns a subset of a table based on a filter. |
| 11. | KEEPFILTERS | KEEPFILTERS(<expression>) | Modifies how filters are applied during evaluation. |
| 12. | LOOKUPVALUE | LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value> [, <search2_columnName>, <search2_value>]… [, <alternateResult>] ) | Returns a value based on search conditions |
| 13. | REMOVEFILTERS | REMOVEFILTERS([<table> | <column>[, <column>[, <column>[,…]]]]) | Clears filters from specified tables or columns. |
| 14. | SELECTEDVALUE | SELECTEDVALUE(<columnName>[, <alternateResult>]) | Returns a value when the context is filtered to one distinct value. |
Financial Functions for Investments and Loans
The following functions help you calculate various aspects of investments and loans:
| S.No | Function | Formula | Description |
| 1. | ACCRINT | ACCRINT(<issue>, <first_interest>, <settlement>, <rate>, <par>, <frequency>[, <basis>[, <calc_method>]]) | Returns the accrued interest for a security that pays periodic interest |
| 2. | ACCRINTM | ACCRINTM(<issue>, <maturity>, <rate>, <par>[, <basis>]) | Returns the accrued interest for a security that pays interest at maturity |
| 3. | AMORDEGRC | AMORDEGRC(<cost>, <date_purchased>, <first_period>, <salvage>, <period>, <rate>[, <basis>]) | Returns the depreciation for each accounting period, considering the asset’s life |
| 4. | AMORLINC | AMORLINC(<cost>, <date_purchased>, <first_period>, <salvage>, <period>, <rat6.e>[, <basis>]) | Returns the depreciation for each accounting period |
| 5. | COUPDAYBS | COUPDAYBS(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the number of days from the beginning of a coupon period until its settlement date |
| 6. | COUPDAYS | COUPDAYS(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the number of days in the coupon period that contains the settlement date |
| 7. | COUPDAYSNC | COUPDAYSNC(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the number of days from the settlement date to the next coupon date |
| 8. | COUPNCD | COUPNCD(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the next coupon date after the settlement date |
| 9. | COUPNUM | COUPNUM(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the number of coupons payable between the settlement date and maturity date |
| 10. | COUPPCD | COUPPCD(<settlement>, <maturity>, <frequency>[, <basis>]) | Returns the previous coupon date before the settlement date |
| 11. | CUMIPMT | CUMIPMT(<rate>, <nper>, <pv>, <start_period>, <end_period>, <type>) | Returns the cumulative interest paid on a loan |
| 12. | CUMPRINC | CUMPRINC(<rate>, <nper>, <pv>, <start_period>, <end_period>, <type>) | Returns the cumulative principal paid on a loan |
| 13. | DB | DB(<cost>, <salvage>, <life>, <period>[, <month>]) | Returns the depreciation of an asset for a specified period |
| 14. | DDB | DDB(<cost>, <salvage>, <life>, <period>[, <factor>]) | Returns the depreciation of an asset for a specified period |
| 15. | DISC | DISC(<settlement>, <maturity>, <pr>, <redemption>[, <basis>]) | Returns the discount rate for a security |
| 16. | DOLLARDE | DOLLARDE(<fractional_dollar>, <fraction>) | Converts a dollar price to a decimal number |
| 17. | DOLLARFR | DOLLARFR(<decimal_dollar>, <fraction>) | Converts a dollar price to a fraction |
| 18. | DURATION | DURATION(<settlement>, <maturity>, <coupon>, <yld>, <frequency>[, <basis>]) | Returns the Macauley duration for a security |
| 19. | EFFECT | EFFECT(<nominal_rate>, <npery>) – | Returns the effective annual interest rate |
| 20. | FV | FV(<rate>, <nper>, <pmt>[, <pv>[, <type>]]) | Calculates the future value of an investment |
| 21. | INTRATE | INTRATE(<settlement>, <maturity>, <investment>, <redemption>[, <basis>]) | Returns the interest rate for a fully invested security |
| 22. | IPMT | IPMT(<rate>, <per>, <nper>, <pv>[, <fv>[, <type>]]) | Returns the interest payment for a given period |
| 23. | ISPMT | ISPMT(<rate>, <per>, <nper>, <pv>) | Calculates the interest paid for a specified period |
| 24. | MDURATION | MDURATION(<settlement>, <maturity>, <coupon>, <yld>, <frequency>[, <basis>]) | Returns the modified Macauley duration for a security |
| 25. | NOMINAL | NOMINAL(<effect_rate>, <npery>) | Returns the nominal annual interest rate |
| 26. | NPER | NPER(<rate>, <pmt>, <pv>[, <fv>[, <type>]]) | Returns the number of periods for an investment |
| 27. | ODDFPRICE | ODDFPRICE(<settlement>, <maturity>, <issue>, <first_coupon>, <rate>, <yld>, <redemption>, <frequency>[, <basis>]) | Returns the price per $100 face value of a security with an odd first period |
| 28. | ODDFYIELD | ODDFYIELD(<settlement>, <maturity>, <issue>, <first_coupon>, <rate>, <pr>, <redemption>, <frequency>[, <basis>]) | Returns the yield of a security with an odd first period |
| 29. | ODDLPRICE | ODDLPRICE(<settlement>, <maturity>, <last_interest>, <rate>, <yld>, <redemption>, <frequency>[, <basis>]) | Returns the price per $100 face value of a security with an odd last coupon period |
| 30. | ODDLYIELD | ODDLYIELD(<settlement>, <maturity>, <last_interest>, <rate>, <pr>, <redemption>, <frequency>[, <basis>]) | Returns the yield of a security with an odd last period |
| 31. | PDURATION | PDURATION(<rate>, <pv>, <fv>) | Returns the number of periods required by an investment to reach a specified value |
| 32. | PMT | PMT(<rate>, <nper>, <pv>[, <fv>[, <type>]]) | Calculates the payment for a loan |
| 33. | PPMT | PPMT(<rate>, <per>, <nper>, <pv>[, <fv>[, <type>]] | Returns the payment on the principal for a given period. |
| 34. | PRICE | PRICE(<settlement>, <maturity>, <rate>, <yld>, <redemption>, <frequency>[, <basis>]) | Returns the price per $100 face value of a security. |
| 35. | PRICEDISC | PRICEDISC(<settlement>, <maturity>, <discount>, <redemption>[, <basis>]) | Returns the price per $100 face value of a discounted security. |
| 36. | PRICEMAT | PRICEMAT(<settlement>, <maturity>, <issue>, <rate>, <yld>[, <basis>]) | Returns the price per $100 face value of a security that pays interest at maturity |
| 37. | PV | PV(<rate>, <nper>, <pmt>[, <fv>[, <type>]]) | Calculates the present value of a loan or investment |
| 38. | RATE | RATE(<nper>, <pmt>, <pv>[, <fv>[, <type>[, <guess>]]]) | Returns the interest rate per period of an annuity |
| 39. | RECEIVED | RECEIVED(<settlement>, <maturity>, <investment>, <discount>[, <basis>]) | Returns the amount received at maturity for a fully invested security |
| 40. | RRI | RRI(<nper>, <pv>, <fv>) | Returns an equivalent interest rate for the growth of an investment |
| 41. | SLN | SLN(<cost>, <salvage>, <life>) | Returns the straight-line depreciation of an asset |
| 42. | SYD | SYD(<cost>, <salvage>, <life>, <per>) | Returns the sum-of-years’ digits depreciation of an asset |
| 43. | TBILLEQ | TBILLEQ(<settlement>, <maturity>, <discount>) | Returns the bond-equivalent yield for a Treasury bill |
| 44. | TBILLPRICE | TBILLPRICE(<settlement>, <maturity>, <discount>) | Returns the price per $100 face value for a Treasury bill |
| 45. | TBILLYIELD | TBILLYIELD(<settlement>, <maturity>, <pr>) | Returns the yield for a Treasury bill |
| 46. | VDB | VDB(<cost>, <salvage>, <life>, <start_period>, <end_period>[, <factor>[, <no_switch>]]) | Returns the depreciation of an asset for any period |
| 47. | XIRR | XIRR(<table>, <values>, <dates>, [, <guess>[, <alternateResult>]]) | Returns the internal rate of return for a schedule of cash flows |
| 48. | XNPV | XNPV(<table>, <values>, <dates>, <rate>) | Returns the present value for a schedule of cash flows |
| 49. | YIELD | YIELD(<settlement>, <maturity>, <rate>, <pr>, <redemption>, <frequency>[, <basis>]) | Returns the yield on a security |
| 50. | YIELDDISC | YIELDDISC(<settlement>, <maturity>, <pr>, <redemption>[, <basis>]) | Returns the annual yield for a discounted security |
| 51. | YIELDMAT | YIELDMAT(<settlement>, <maturity>, <issue>, <rate>, <pr>[, <basis>]) | Returns the annual yield of a security that pays interest at maturity |
DAX Information Functions
The following functions provide information and insights about data, calculations, and the current user:
| S.No | Function | Formula | Description |
| 1. | CONTAINS | CONTAINS(<table>, <columnName>, <value>[, <columnName>, <value>]…) | Returns True if all referred values exist in the specified columns |
| 2. | CONTAINSROW | CONTAINSROW(<Table>, <Value> [, <Value> [, …] ] ) | Returns True if a row of values exists in a table |
| 3. | CONTAINSSTRING | CONTAINSSTRING(<within_text>, <find_text>) | Returns True if one string contains another string |
| 4. | CONTAINSSTRINGEXACT | CONTAINSSTRINGEXACT(<within_text>, <find_text>) | Returns True if one string contains another string, with exact matching |
| 5. | CUSTOMDATA | CUSTOMDATA() | Returns custom data from the connection string |
| 6. | HASONEFILTER | HASONEFILTER(<columnName>) | Returns True if a column has only one directly filtered value |
| 7. | HASONEVALUE | HASONEVALUE(<columnName>) | Returns True if a column has only one distinct value in the current context |
| 8. | ISAFTER | ISAFTER(<scalar_expression>, <scalar_expression>[, sort_order [, <scalar_expression>, <scalar_expression>[, sort_order]]…) | Returns True if a row meets all condition parameters |
| 9. | ISBLANK | ISBLANK(<value>) | Returns True if a value is blank |
| 10. | ISCROSSFILTERED | ISCROSSFILTERED(<TableNameOrColumnName>) | Returns True if a column or related column is being filtered |
| 11. | ISEMPTY | ISEMPTY(<table_expression>) | Returns True if a table is empty |
| 12. | ISERROR | ISERROR(<value>) | Returns True if a value is an error |
| 13. | ISEVEN | ISEVEN(number) | Returns True if a number is even |
| 14. | ISFILTERED | ISFILTERED(<TableNameOrColumnName>) | Returns True if a column is being directly filtered |
| 15. | ISINSCOPE | ISINSCOPE(<columnName>) | Returns True if a column is the current level in a hierarchy |
| 16. | ISLOGICAL | ISLOGICAL(<value>) | Returns True if a value is a logical value (True or False) |
| 17. | ISNONTEXT | ISNONTEXT(<value>) | Returns True if a value is not text |
| 18. | ISNUMBER | ISNUMBER(<value>) | Returns True if a value is a number |
| 19. | ISODD | ISODD(number) | Returns True if a number is odd |
| 20. | ISSELECTEDMEASURE | ISSELECTEDMEASURE( M1, M2, … ) | Returns True if the selected measure is one of the specified measures |
| 21. | ISSUBTOTAL | ISSUBTOTAL(<columnName>) | Returns True if a row contains subtotal values for the specified column |
| 22. | ISTEXT | ISTEXT(<value>) | Returns True if a value is text |
| 23. | NONVISUAL | NONVISUAL(<expression>) | Marks a value filter as non-visual |
| 24. | SELECTEDMEASURE | SELECTEDMEASURE() | Returns the selected measure |
| 25. | SELECTEDMEASUREFORMATSTRING | SELECTEDMEASUREFORMATSTRING() | Returns the format string of the selected measure |
| 26. | SELECTEDMEASURENAME | SELECTEDMEASURENAME() | Returns the name of the selected measure |
| 27. | USERNAME | USERNAME() | Returns the domain name and username |
| 28. | USEROBJECTID | USEROBJECTID() | Returns the current user’s Object ID or SID |
| 29. | USERPRINCIPALNAME | USERPRINCIPALNAME() | Returns the user principal name |
DAX Logical Functions
The following functions help you perform logical operations and make decisions in your calculations:
| S.No | Function | Formula | Description |
| 1. | AND | AND(<logical1>,<logical2>) | Returns True if both conditions are met |
| 2. | BITAND | BITAND(<number>, <number>) – | Performs a bitwise AND operation on two numbers |
| 3. | BITLSHIFT | BITLSHIFT(<Number>, <Shift_Amount>) | Shifts the bits of a number to the left |
| 4. | BITOR | BITOR(<number>, <number>) | Performs a bitwise OR operation on two numbers |
| 5. | BITRSHIFT | BITRSHIFT(<Number>, <Shift_Amount>) | Shifts the bits of a number to the right |
| 6. | BITXOR | BITXOR(<number>, <number>) | Performs a bitwise XOR operation on two numbers |
| 7. | COALESCE | COALESCE(<expression>, <expression>[, <expression>]…) | Returns the first non-blank expression |
| 8. | FALSE | FALSE() | Returns the logical value False |
| 9. | IF | IF(<logical_test>, <value_if_true>[, <value_if_false>]) | Tests a condition and returns one value if true, another value if false |
| 10. | IF.EAGER | IF.EAGER(<logical_test>, <value_if_true>[, <value_if_false>]) | Similar to IF, but always evaluates both branches |
| 11. | IFERROR | IFERROR(value, value_if_error) | Returns a specified value if the expression returns an error |
| 12. | NOT | NOT(<logical>) | Reverses the logical value (True becomes False, False becomes True) |
| 13. | OR | OR(<logical1>,<logical2>) | Returns True if either condition is met |
| 14. | SWITCH | SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>]) | Evaluates an expression and returns one of multiple possible results |
| 15. | TRUE | TRUE() | Returns the logical value True |
Math And Trig Functions
The following functions help you perform mathematical and trigonometric operations in your calculations:
| S.No. | Function | Formula | Description |
| 1. | ABS | ABS(<number>) | Returns the absolute value of a number |
| 2. | ACOS | ACOS(number) | Returns the angle whose cosine is the given number |
| 3. | ACOSH | ACOSH(number) | Returns the inverse hyperbolic cosine of a number |
| 4. | ACOT | ACOT(number) | Returns the angle whose cotangent is the given number |
| 5. | ACOTH | ACOTH(number) | Returns the inverse hyperbolic cotangent of a number |
| 6. | ASIN | ASIN(number) | Returns the angle whose sine is the given number. |
| 7. | ASINH | ASINH(number) | Returns the inverse hyperbolic sine of a number |
| 8. | ATAN | ATAN(number) | Returns the angle whose tangent is the given number |
| 9. | ATANH | ATANH(number) | Returns the inverse hyperbolic tangent of a number |
| 10. | CEILING | CEILING(<number>, <significance>) | Rounds a number up to the nearest integer or multiple |
| 11. | CONVERT | CONVERT(<Expression>, <Datatype>) | Converts an expression to a different data type |
| 12. | COS | COS(number). | Returns the cosine of an angle |
| 13. | COSH | COSH(number) | Returns the hyperbolic cosine of a number |
| 14 | COT | COT (<number>) | Returns the cotangent of an angle |
| 15. | COTH | COTH (<number>) | Returns the hyperbolic cotangent of a number |
| 16. | CURRENCY | CURRENCY(<value>) | Evaluates an expression and returns the result as currency |
| 17. | DEGREES | DEGREES(angle) | Converts radians to degrees |
| 18. | DIVIDE | DIVIDE(<numerator>, <denominator> [,<alternateresult>]) | Performs division and returns an alternate result or blank on division by zero. |
| 19. | EVEN | EVEN(number) | Rounds a number up to the nearest even integer |
| 20. | EXP | EXP(<number>) | Returns e raised to a power. |
| 21. | FACT | FACT(<number>) | Returns the factorial of a number. |
| 22. | FLOOR | FLOOR(<number>, <significance>) | Rounds a number down to the nearest integer or multiple |
| 23. | GCD | GCD(number1, [number2], …) | Returns the greatest common divisor of two or more integers |
| 24. | INT | INT(<number>) | Rounds a number down to the nearest integer |
| 25. | ISO.CEILING | ISO.CEILING(<number>[, <significance>]) | Rounds a number up to the nearest integer or multiple |
| 26. | LCM | LCM(number1, [number2], …) | Returns the least common multiple of integers |
| 27. | LN | LN(<number>) | Returns the natural logarithm of a number. |
| 28. | LOG | LOG(<number>,<base>) | Returns the logarithm of a number to a specified base. |
| 29. | LOG10 | LOG10(<number>) | Returns the base-10 logarithm of a number. |
| 30. | MOD | MOD(<number>, <divisor>) | Returns the remainder of division. |
| 31. | MROUND | MROUND(<number>, <multiple>) | Rounds a number to a multiple |
| 32. | ODD | ODD(number) | Rounds a number up to the nearest odd integer |
| 33. | PI | PI() | Returns the value of Pi |
| 34. | POWER | POWER(<number>, <power>) | Returns a number raised to a power |
| 35. | QUOTIENT | QUOTIENT(<numerator>, <denominator>) | Performs division and returns the integer part |
| 36. | RADIANS | RADIANS(angle) | Converts degrees to radians |
| 37. | RAND | RAND() | Returns a random number between 0 and 1 |
| 38. | RANDBETWEEN | RANDBETWEEN(<bottom>,<top>) | Returns a random number between two numbers |
| 39. | ROUND | ROUND(<number>, <num_digits>) | Rounds a number to a specified number of digits |
| 40. | ROUNDDOWN | ROUNDDOWN(<number>, <num_digits>) | Rounds a number down |
| 41. | ROUNDUP | ROUNDUP(<number>, <num_digits>) | Rounds a number up, away from zero |
| 42. | SIGN | SIGN(<number>) | Determines the sign of a number, calculation result, or column value |
| 43. | SIN | SIN(number) | Returns the sine of a given angle |
| 44. | SINH | SINH(number) | Returns the hyperbolic sine of a number |
| 45. | SQRT | SQRT(<number>) | Returns the square root of a number |
| 46. | SQRPTPI | SQRTPI(number) | Returns the square root of the product of a number and pi |
| 47. | TAN | TAN(number) | Returns the tangent of a given angle |
| 48. | TANH | TANH(number) | Returns the hyperbolic tangent of a number |
| 49. | TRUNC | TRUNC(<number>,<num_digits>) | Truncates a number to an integer by removing the decimal or fractional part |
You may like to read other blocks i.e.
