Latest updates


2020-09-26

Function Category Description
ISAFTER Information Returns true if the list of Value1 parameters compares strictly after the list of Value2 parameters.

2020-09-11

Function Category Description
USERCULTURE Information Returns the culture code for the user, based on their operating system or browser settings.

2020-06-21

Function Category Description
ACCRINT Financial Returns the accrued interest for a security that pays periodic interest.
ACCRINTM Financial Returns the accrued interest for a security that pays interest at maturity.
AMORDEGRC Financial Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. The function is similar to AMORLINC, except that a depreciation coefficient is applied in the calculation depending on the life of the assets.
AMORLINC Financial Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.
COUPDAYBS Financial Returns the number of days from the beginning of a coupon period until its settlement date.
COUPDAYS Financial Returns the number of days in the coupon period that contains the settlement date.
COUPDAYSNC Financial Returns the number of days from the settlement date to the next coupon date.
COUPNCD Financial Returns the next coupon date after the settlement date.
COUPNUM Financial Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
COUPPCD Financial Returns the previous coupon date before the settlement date.
CUMIPMT Financial Returns the cumulative interest paid on a loan between start_period and end_period.
CUMPRINC Financial Returns the cumulative principal paid on a loan between start_period and end_period.
DB Financial Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
DDB Financial Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
DISC Financial Returns the discount rate for a security.
DOLLARDE Financial 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. Fractional dollar numbers are sometimes used for securities prices.
DOLLARFR Financial Converts a dollar price expressed as a decimal number into a dollar price expressed as an integer part and a fraction part, such as 1.02. Fractional dollar numbers are sometimes used for securities prices.
DURATION Financial Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price's response to changes in yield.
EFFECT Financial Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
FV Financial Calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment.
INTRATE Financial Returns the interest rate for a fully invested security.
IPMT Financial Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
ISPMT Financial Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments.
MDURATION Financial Returns the modified Macauley duration for a security with an assumed par value of $100.
NOMINAL Financial Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
NPER Financial Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
ODDFPRICE Financial Returns the price per $100 face value of a security having an odd (short or long) first period.
ODDFYIELD Financial Returns the yield of a security that has an odd (short or long) first period.
ODDLPRICE Financial Returns the price per $100 face value of a security having an odd (short or long) last period.
ODDLYIELD Financial Returns the yield of a security that has an odd (short or long) last period.
PDURATION Financial Returns the number of periods required by an investment to reach a specified value.
PMT Financial Calculates the payment for a loan based on constant payments and a constant interest rate.
PPMT Financial Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
PRICE Financial Returns the price per $100 face value of a security that pays periodic interest.
PRICEDISC Financial Returns the price per $100 face value of a discounted security.
PRICEMAT Financial Returns the price per $100 face value of a security that pays interest at maturity.
PV Financial calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that's your investment goal.
RATE Financial Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, RATE returns an error.
RECEIVED Financial Returns the amount received at maturity for a fully invested security.
RRI Financial Returns an equivalent interest rate for the growth of an investment.
SLN Financial Returns the straight-line depreciation of an asset for one period.
SYD Financial Returns the sum-of-years' digits depreciation of an asset for a specified period.
TBILLEQ Financial Returns the bond-equivalent yield for a Treasury bill.
TBILLPRICE Financial Returns the price per $100 face value for a Treasury bill.
TBILLYIELD Financial Returns the yield for a Treasury bill.
VDB Financial 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. VDB stands for variable declining balance.
YIELD Financial Returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield.
YIELDDISC Financial Returns the annual yield for a discounted security.
YIELDMAT Financial Returns the annual yield of a security that pays interest at maturity.

2020-02-25

Function Category Description
COALESCE Logical Returns the first argument that does not evaluate to a blank value. If all arguments evaluate to blank values, BLANK is returned.

2020-01-30

Function Category Description
IF.EAGER Logical Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. Uses eager execution.

2019-12-05

Function Category Description
FIRSTNONBLANKVALUE Time Intelligence Returns the first non blank value of the expression that evaluated for the column.
LASTNONBLANKVALUE Time Intelligence Returns the last non blank value of the expression that evaluated for the column.
QUARTER Date and Time Returns a number from 1 (January-March) to 4 (October-December) representing the quarter.

2019-11-20

Function Category Description
TOPNPERLEVEL Table manipulation

2019-08-22

Function Category Description
CONVERT Math and Trig Convert an expression to the specified data type.
REMOVEFILTERS Filter Clear filters from the specified tables or columns.

2019-05-18

Function Category Description
SELECTEDMEASUREFORMATSTRING Information Returns format string for the measure that is currently being evaluated.

2019-03-25

Function Category Description
ALLCROSSFILTERED Filter Clear all filters which are applied to the specified table.
ISSELECTEDMEASURE Information Returns true if one of the specified measures is currently being evaluated.

2019-02-22

Function Category Description
CONTAINSSTRING Information Returns TRUE if one text string contains another text string. CONTAINSSTRING is not case-sensitive, but it is accent-sensitive.
CONTAINSSTRINGEXACT Information Returns TRUE if one text string contains another text string. CONTAINSSTRINGEXACT is case-sensitive and accent-sensitive.
DISTINCTCOUNTNOBLANK Aggregation Counts the number of distinct values in a column.

2018-11-30

Function Category Description
APPROXIMATEDISTINCTCOUNT Aggregation Counts the approximate number of distinct values in a column. Currently this function is only available on a DirectQuery table from Azure SQL or Azure SQL Data Warehouse.

2018-10-31

Function Category Description
ISINSCOPE Information Returns true when the specified column is the level in a hierarchy of levels.

2018-09-25

Function Category Description
NONVISUAL Table manipulation Mark the filter as NonVisual.

2018-07-04

Function Category Description
NORM.DIST Statistical Returns the normal distribution for the specified mean and standard deviation.
NORM.INV Statistical Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORM.S.DIST Statistical Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
NORM.S.INV Statistical Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
T.DIST Statistical Returns the Student's left-tailed t-distribution.
T.DIST.2T Statistical Returns the two-tailed Student's t-distribution.
T.DIST.RT Statistical Returns the right-tailed Student's t-distribution.
T.INV Statistical Returns the left-tailed inverse of the Student's t-distribution.
T.INV.2T Statistical Returns the two-tailed inverse of the Student's t-distribution.

2018-04-13

Function Category Description
TOPNSKIP Table manipulation Retrieves a number of rows from a table efficiently, skipping a number of rows. Compared to TOPN, the TOPNSKIP function is less flexible, but much faster.

2018-04-09

Function Category Description
SELECTEDMEASURE Information Returns the measure that is currently being evaluated.
SELECTEDMEASURENAME Information Returns name of the measure that is currently being evaluated.

2018-02-06

Function Category Description
UTCNOW Date and Time Returns the current date and time in datetime format expressed in Coordinated Universal Time (UTC).
UTCTODAY Date and Time Returns the current date in datetime format expressed in Coordinated Universal Time (UTC).

2017-11-08

Function Category Description
COMBINEVALUES Text Combines the given set of operands using a specified delimiter.

2017-08-09

Function Category Description
GENERATESERIES Table manipulation Returns a table with one column, populated with sequential values from start to end.

2017-07-06

Function Category Description
SELECTEDVALUE Filter Returns the value when there's only one value in the specified column, otherwise returns the alternate result.

2017-05-03

Function Category Description
USEROBJECTID Information Returns the current user's Object ID from Azure AD for Azure Analysis Server and the current user's SID for on-premise Analysis Server.

2017-04-06

Function Category Description
ERROR Other Raises a user specified error.

2017-02-26

Function Category Description
UNICHAR Text Returns the Unicode character that is referenced by the given numeric value.

2017-02-09

Function Category Description
TREATAS Table manipulation Treats the columns of the input table as columns from other tables.For each column, filters out any values that are not present in its respective output column.

2017-01-03

Function Category Description
DETAILROWS Table manipulation Returns the table data corresponding to the DetailRows expression defined on the specified Measure. If a DetailRows expression is not defined then the entire table to which the Measure belongs is returned.

2017-01-02

Function Category Description
CONTAINSROW Information Returns TRUE if there exists at least one row where all columns have specified values.
DATATABLE Table manipulation Returns a table with data defined inline.
USERPRINCIPALNAME Information Returns the user principal name.

Before 2017-01-01

Function Category Description
ABS Math and Trig Returns the absolute value of a number.
ACOS Math and Trig Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi.
ACOSH Math and Trig Returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number.
ACOT Math and Trig Returns the principal value of the arccotangent, or inverse cotangent, of a number.
ACOTH Math and Trig Returns the inverse hyperbolic cotangent of a number.
ADDCOLUMNS Table manipulation Returns a table with new columns specified by the DAX expressions.
ADDMISSINGITEMS Table manipulation Add the rows with empty measure values back.
ALL Filter Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied.
ALLEXCEPT Filter Returns all the rows in a table except for those rows that are affected by the specified column filters.
ALLNOBLANKROW Filter Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been applied.
ALLSELECTED Filter Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied inside the query, but keeping filters that come from outside.
AND Logical Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.
ASIN Math and Trig Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2.
ASINH Math and Trig Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number, so ASINH(SINH(number)) equals number.
ATAN Math and Trig Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2.
ATANH Math and Trig Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose hyperbolic tangent is number, so ATANH(TANH(number)) equals number.
AVERAGE Aggregation Returns the average (arithmetic mean) of all the numbers in a column.
AVERAGEA Aggregation Returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.
AVERAGEX Aggregation Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.
BETA.DIST Statistical Returns the beta distribution. The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
BETA.INV Statistical Returns the inverse of the beta cumulative probability density function (BETA.DIST). If probability = BETA.DIST(x,...TRUE), then BETA.INV(probability,...) = x. The beta distribution can be used in project planning to model probable completion times given an expected completion time and variability.
BLANK Other Returns a blank.
CALCULATE Filter Evaluates an expression in a context modified by filters.
CALCULATETABLE Filter Evaluates a table expression in a context modified by filters.
CALENDAR Date and Time Returns a table with one column of all dates between StartDate and EndDate.
CALENDARAUTO Date and Time Returns a table with one column of dates calculated from the model automatically.
CEILING Math and Trig Rounds a number up, to the nearest integer or to the nearest unit of significance.
CHISQ.DIST Statistical Returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
CHISQ.DIST.RT Statistical Returns the right-tailed probability of the chi-squared distribution. The chi-squared distribution is associated with a chi-squared test. Use the chi-squared test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants will exhibit a certain set of colors. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid.
CHISQ.INV Statistical Returns the inverse of the left-tailed probability of the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
CHISQ.INV.RT Statistical Returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHISQ.DIST.RT(x,...), then CHISQ.INV.RT(probability,...) = x. Use this function to compare observed results with expected ones in order to decide whether your original hypothesis is valid.
CLOSINGBALANCEMONTH Time Intelligence Evaluates the specified expression for the date corresponding to the end of the current month after applying specified filters.
CLOSINGBALANCEQUARTER Time Intelligence Evaluates the specified expression for the date corresponding to the end of the current quarter after applying specified filters.
CLOSINGBALANCEYEAR Time Intelligence Evaluates the specified expression for the date corresponding to the end of the current year after applying specified filters.
COMBIN Statistical Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.
COMBINA Statistical Returns the number of combinations (with repetitions) for a given number of items.
CONCATENATE Text Joins two text strings into one text string.
CONCATENATEX Text Evaluates expression for each row on the table, then return the concatenation of those values in a single string result, seperated by the specified delimiter.
CONFIDENCE.NORM Statistical Returns the confidence interval for a population mean, using a normal distribution.
CONFIDENCE.T Statistical Returns the confidence interval for a population mean, using a Student's t distribution.
CONTAINS Information Returns TRUE if there exists at least one row where all columns have specified values.
COS Math and Trig Returns the cosine of the given angle.
COSH Math and Trig Returns the hyperbolic cosine of a number.
COT Math and Trig Return the cotangent of an angle specified in radians.
COTH Math and Trig Return the hyperbolic cotangent of a hyperbolic angle.
COUNT Aggregation Counts the number of rows in the table where the specified column has a non-blank value.
COUNTA Aggregation Counts the number of values in a column.
COUNTAX Aggregation Counts the number of values which result from evaluating an expression for each row of a table.
COUNTBLANK Aggregation Counts the number of blanks in a column.
COUNTROWS Aggregation Counts the number of rows in a table.
COUNTX Aggregation Counts the number of values which result from evaluating an expression for each row of a table.
CROSSFILTER Relationships management Specifies cross filtering direction to be used in the evaluation of a DAX expression. The relationship is defined by naming, as arguments, the two columns that serve as endpoints.
CROSSJOIN Table manipulation Returns a table that is a crossjoin of the specified tables.
CURRENCY Math and Trig Returns the value as a currency data type.
CURRENTGROUP Table manipulation Access to the (sub)table representing current group in GroupBy function. Can be used only inside GroupBy function.
CUSTOMDATA Information Returns the value of the CustomData connection string property if defined; otherwise, BLANK().
DATE Date and Time Returns the specified date in datetime format.
DATEADD Time Intelligence Moves the given set of dates by a specified interval.
DATEDIFF Date and Time Returns the number of units (unit specified in Interval) between the input two dates.
DATESBETWEEN Time Intelligence Returns the dates between two given dates.
DATESINPERIOD Time Intelligence Returns the dates from the given period.
DATESMTD Time Intelligence Returns a set of dates in the month up to the last date visible in the filter context.
DATESQTD Time Intelligence Returns a set of dates in the quarter up to the last date visible in the filter context.
DATESYTD Time Intelligence Returns a set of dates in the year up to the last date visible in the filter context.
DATEVALUE Date and Time Converts a date in the form of text to a date in datetime format.
DAY Date and Time Returns a number from 1 to 31 representing the day of the month.
DEGREES Math and Trig Converts radians into degrees.
DISTINCT Table manipulation Returns a one column table that contains the distinct (unique) values in a column, for a column argument. Or multiple columns with distinct (unique) combination of values, for a table expression argument.
DISTINCTCOUNT Aggregation Counts the number of distinct values in a column.
DIVIDE Math and Trig Safe Divide function with ability to handle divide by zero case.
EARLIER Other Returns the value in the column prior to the specified number of table scans (default is 1).
EARLIEST Other Returns the value in the column for the very first point at which there was a row context.
EDATE Date and Time Returns the date that is the indicated number of months before or after the start date.
ENDOFMONTH Time Intelligence Returns the end of month.
ENDOFQUARTER Time Intelligence Returns the end of quarter.
ENDOFYEAR Time Intelligence Returns the end of year.
EOMONTH Date and Time Returns the date in datetime format of the last day of the month before or after a specified number of months.
EVEN Math and Trig Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate's capacity.
EXACT Text Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive.
EXCEPT Table manipulation Returns the rows of left-side table which do not appear in right-side table.
EXP Math and Trig Returns e raised to the power of a given number.
EXPON.DIST Statistical Returns the exponential distribution. Use EXPON.DIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPON.DIST to determine the probability that the process takes at most 1 minute.
FACT Math and Trig Returns the factorial of a number, equal to 1*2*3*...* Number.
FALSE Logical Returns the logical value FALSE.
FILTER Filter Returns a table that has been filtered.
FILTERS Table manipulation Returns a table of the filter values applied directly to the specified column.
FIND Text Returns the starting position of one text string within another text string. FIND is case-sensitive and accent-sensitive.
FIRSTDATE Time Intelligence Returns first non blank date.
FIRSTNONBLANK Time Intelligence Returns the first value in the column for which the expression has a non blank value.
FIXED Text Rounds a number to the specified number of decimals and returns the result as text with optional commas.
FLOOR Math and Trig Rounds a number down, toward zero, to the nearest multiple of significance.
FORMAT Text Converts a value to text in the specified number format.
GCD Math and Trig Returns the greatest common divisor of two integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
GENERATE Table manipulation The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table with these results.
GENERATEALL Table manipulation The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table with these results, including rows for which the second table expression is empty.
GEOMEAN Statistical Returns geometric mean of given column reference.
GEOMEANX Statistical Returns geometric mean of an expression values in a table.
GROUPBY Table manipulation Creates a summary the input table grouped by the specified columns.
HASONEFILTER Information Returns true when the specified table or column has one and only one value resulting from direct filter(s).
HASONEVALUE Information Returns true when there's only one value in the specified column.
HOUR Date and Time Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
IF Logical Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.
IFERROR Logical Returns value_if_error if the first expression is an error and the value of the expression itself otherwise.
IGNORE Table manipulation Tags a measure expression specified in the call to SUMMARIZECOLUMNS function to be ignored when determining the non-blank rows.
INT Math and Trig Rounds a number down to the nearest integer.
INTERSECT Table manipulation Returns the rows of left-side table which appear in right-side table.
ISBLANK Information Checks whether a value is blank, and returns TRUE or FALSE.
ISCROSSFILTERED Information Returns true when the specified table or column is crossfiltered.
ISEMPTY Information Returns true if the specified table or table-expression is Empty.
ISERROR Information Checks whether a value is an error, and returns TRUE or FALSE.
ISEVEN Information Returns TRUE if number is even, or FALSE if number is odd.
ISFILTERED Information Returns true when there are direct filters on the specified column.
ISLOGICAL Information Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.
ISNONTEXT Information Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE.
ISNUMBER Information Checks whether a value is a number, and returns TRUE or FALSE.
ISO.CEILING Math and Trig Rounds a number up, to the nearest integer or to the nearest multiple of significance.
ISODD Information Returns TRUE if number is odd, or FALSE if number is even.
ISONORAFTER Information The IsOnOrAfter function is a boolean function that emulates the behavior of Start At clause and returns true for a row that meets all the conditions mentioned as parameters in this function.
ISSUBTOTAL Information Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise.
ISTEXT Information Checks whether a value is text, and returns TRUE or FALSE.
KEEPFILTERS Filter Changes the CALCULATE and CALCULATETABLE function filtering semantics.
KEYWORDMATCH Other Returns TRUE if there is a match between the MatchExpression and Text.
LASTDATE Time Intelligence Returns last non blank date.
LASTNONBLANK Time Intelligence Returns the last value in the column for which the expression has a non blank value.
LCM Math and Trig Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of both integer arguments number1, number2. Use LCM to add fractions with different denominators.
LEFT Text Returns the specified number of characters from the start of a text string.
LEN Text Returns the number of characters in a text string.
LN Math and Trig Returns the natural logarithm of a number.
LOG Math and Trig Returns the logarithm of a number to the base you specify.
LOG10 Math and Trig Returns the base-10 logarithm of a number.
LOOKUPVALUE Filter Retrieves a value from a table.
LOWER Text Converts all letters in a text string to lowercase.
MAX Aggregation Returns the largest value in a column, or the larger value between two scalar expressions. Ignores logical values. Strings are compared according to alphabetical order.
MAXA Aggregation Returns the largest value in a column. Does not ignore logical values and text.
MAXX Aggregation Returns the largest value that results from evaluating an expression for each row of a table. Strings are compared according to alphabetical order.
MEDIAN Statistical Returns the 50th percentile of values in a column.
MEDIANX Statistical Returns the 50th percentile of an expression values in a table.
MID Text Returns a string of characters from the middle of a text string, given a starting position and length.
MIN Aggregation Returns the smallest value in a column, or the smaller value between two scalar expressions. Ignores logical values. Strings are compared according to alphabetical order.
MINA Aggregation Returns the smallest value in a column. Does not ignore logical values and text.
MINUTE Date and Time Returns a number from 0 to 59 representing the minute.
MINX Aggregation Returns the smallest value that results from evaluating an expression for each row of a table. Strings are compared according to alphabetical order.
MOD Math and Trig Returns the remainder after a number is divided by a divisor.
MONTH Date and Time Returns a number from 1 (January) to 12 (December) representing the month.
MROUND Math and Trig Returns a number rounded to the desired multiple.
NATURALINNERJOIN Table manipulation Joins the Left table with right table using the Inner Join semantics.
NATURALLEFTOUTERJOIN Table manipulation Joins the Left table with right table using the Left Outer Join semantics.
NEXTDAY Time Intelligence Returns a next day.
NEXTMONTH Time Intelligence Returns a next month.
NEXTQUARTER Time Intelligence Returns a next quarter.
NEXTYEAR Time Intelligence Returns a next year.
NOT Logical Changes FALSE to TRUE, or TRUE to FALSE.
NOW Date and Time Returns the current date and time in datetime format.
ODD Math and Trig Returns number rounded up to the nearest odd integer.
OPENINGBALANCEMONTH Time Intelligence Evaluates the specified expression for the date corresponding to the end of the previous month after applying specified filters.
OPENINGBALANCEQUARTER Time Intelligence Evaluates the specified expression for the date corresponding to the end of the previous quarter after applying specified filters.
OPENINGBALANCEYEAR Time Intelligence Evaluates the specified expression for the date corresponding to the end of the previous year after applying specified filters.
OR Logical Returns TRUE if any of the arguments are TRUE, and returns FALSE if all arguments are FALSE.
PARALLELPERIOD Time Intelligence Returns a parallel period of dates by the given set of dates and a specified interval.
PATH Parent-child Returns a string which contains a delimited list of IDs, starting with the top/root of a hierarchy and ending with the specified ID.
PATHCONTAINS Parent-child Returns TRUE if the specified Item exists within the specified Path.
PATHITEM Parent-child Returns the nth item in the delimited list produced by the Path function.
PATHITEMREVERSE Parent-child Returns the nth item in the delimited list produced by the Path function, counting backwards from the last item in the path.
PATHLENGTH Parent-child Returns returns the number of items in a particular path string. This function returns 1 for the path generated for an ID at the top/root of a hierarchy.
PERCENTILE.EXC Statistical Returns the k-th (exclusive) percentile of values in a column.
PERCENTILE.INC Statistical Returns the k-th (inclusive) percentile of values in a column.
PERCENTILEX.EXC Statistical Returns the k-th (exclusive) percentile of an expression values in a table.
PERCENTILEX.INC Statistical Returns the k-th (inclusive) percentile of an expression values in a table.
PERMUT Statistical Returns the number of permutations for a given number of objects that can be selected from number objects. A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from combinations, for which the internal order is not significant. Use this function for lottery-style probability calculations.
PI Math and Trig Returns the value of π, 3.14159265358979, accurate to 15 digits.
POISSON.DIST Statistical Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.
POWER Math and Trig Returns the result of a number raised to a power.
PREVIOUSDAY Time Intelligence Returns a previous day.
PREVIOUSMONTH Time Intelligence Returns a previous month.
PREVIOUSQUARTER Time Intelligence Returns a previous quarter.
PREVIOUSYEAR Time Intelligence Returns a previous year.
PRODUCT Aggregation Returns the product of given column reference.
PRODUCTX Aggregation Returns the product of an expression values in a table.
QUOTIENT Math and Trig Returns the integer portion of a division.
RADIANS Math and Trig Converts degrees to radians.
RAND Math and Trig Returns a random number greater than or equal to 0 and less than 1, evenly distributed. Random numbers change on recalculation.
RANDBETWEEN Math and Trig Returns a random number between the numbers you specify.
RANK.EQ Statistical Returns the rank of a number in a column of numbers. If more than one value has the same rank, the top rank of that set of values is returned.
RANKX Statistical Returns the rank of an expression evaluated in the current context in the list of values for the expression evaluated for each row in the specified table.
RELATED Relationships management Returns a related value from another table.
RELATEDTABLE Relationships management Returns the related tables filtered so that it only includes the related rows.
REPLACE Text Replaces part of a text string with a different text string.
REPT Text Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
RIGHT Text Returns the specified number of characters from the end of a text string.
ROLLUP Table manipulation Identifies a subset of columns specified in the call to SUMMARIZE function that should be used to calculate subtotals.
ROLLUPADDISSUBTOTAL Table manipulation Identifies a subset of columns specified in the call to SUMMARIZECOLUMNS function that should be used to calculate groups of subtotals.
ROLLUPGROUP Table manipulation Identifies a subset of columns specified in the call to SUMMARIZE function that should be used to calculate groups of subtotals.
ROLLUPISSUBTOTAL Table manipulation Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL.
ROUND Math and Trig Rounds a number to a specified number of digits.
ROUNDDOWN Math and Trig Rounds a number down, toward zero.
ROUNDUP Math and Trig Rounds a number up, away from zero.
ROW Table manipulation Returns a single row table with new columns specified by the DAX expressions.
SAMEPERIODLASTYEAR Time Intelligence Returns a set of dates in the current selection from the previous year.
SAMPLE Statistical Returns a sample subset from a given table expression.
SEARCH Text Returns the starting position of one text string within another text string. SEARCH is not case-sensitive, but it is accent-sensitive.
SECOND Date and Time Returns a number from 0 to 59 representing the second.
SELECTCOLUMNS Table manipulation Returns a table with selected columns from the table and new columns specified by the DAX expressions.
SIGN Math and Trig Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative.
SIN Math and Trig Returns the sine of the given angle.
SINH Math and Trig Returns the hyperbolic sine of a number.
SQRT Math and Trig Returns the square root of a number.
SQRTPI Math and Trig Returns the square root of (number * pi).
STARTOFMONTH Time Intelligence Returns the start of month.
STARTOFQUARTER Time Intelligence Returns the start of quarter.
STARTOFYEAR Time Intelligence Returns the start of year.
STDEV.P Statistical Calculates standard deviation based on the entire population given as arguments. Ignores logical values and text.
STDEV.S Statistical Estimates standard deviation based on a sample. Ignores logical values and text in the sample.
STDEVX.P Statistical Estimates standard deviation based on the entire population that results from evaluating an expression for each row of a table.
STDEVX.S Statistical Estimates standard deviation based on a sample that results from evaluating an expression for each row of a table.
SUBSTITUTE Text Replaces existing text with new text in a text string.
SUBSTITUTEWITHINDEX Table manipulation Returns a table which represents the semijoin of two tables supplied and for which the common set of columns are replaced by a 0-based index column. The index is based on the rows of the second table sorted by specified order expressions.
SUM Aggregation Adds all the numbers in a column.
SUMMARIZE Table manipulation Creates a summary of the input table grouped by the specified columns.
SUMMARIZECOLUMNS Table manipulation Create a summary table for the requested totals over set of groups.
SUMX Aggregation Returns the sum of an expression evaluated for each row in a table.
SWITCH Logical Returns different results depending on the value of an expression.
TAN Math and Trig Returns the tangent of the given angle.
TANH Math and Trig Returns the hyperbolic tangent of a number.
TIME Date and Time Converts hours, minutes, and seconds given as numbers to a time in datetime format.
TIMEVALUE Date and Time Converts a time in text format to a time in datetime format.
TODAY Date and Time Returns the current date in datetime format.
TOPN Table manipulation Returns a given number of top rows according to a specified expression.
TOTALMTD Time Intelligence Evaluates the specified expression over the interval which begins on the first of the month and ends with the last date in the specified date column after applying specified filters.
TOTALQTD Time Intelligence Evaluates the specified expression over the interval which begins on the first day of the quarter and ends with the last date in the specified date column after applying specified filters.
TOTALYTD Time Intelligence Evaluates the specified expression over the interval which begins on the first day of the year and ends with the last date in the specified date column after applying specified filters.
TRIM Text Removes all spaces from a text string except for single spaces between words.
TRUE Logical Returns the logical value TRUE.
TRUNC Math and Trig Truncates a number to an integer by removing the decimal, or fractional, part of the number.
UNICODE Text Returns the number (code point) corresponding to the first character of the text.
UNION Table manipulation Returns the union of the tables whose columns match.
UPPER Text Converts a text string to all uppercase letters.
USERELATIONSHIP Relationships management Specifies an existing relationship to be used in the evaluation of a DAX expression. The relationship is defined by naming, as arguments, the two columns that serve as endpoints.
USERNAME Information Returns the domain name and user name of the current connection with the format of domain-name\user-name.
VALUE Text Converts a text string that represents a number to a number.
VALUES Table manipulation When a column name is given, returns a single column table of unique values. When a table name is given, returns a table with the same columns and all the rows of the table (including duplicates) with the additional blank row if present.
VAR.P Statistical Calculates variance based on the entire population. Ignores logical values and text in the population.
VAR.S Statistical Estimates variance based on a sample. Ignores logical values and text in the sample.
VARX.P Statistical Estimates variance based on the entire population that results from evaluating an expression for each row of a table.
VARX.S Statistical Estimates variance based on a sample that results from evaluating an expression for each row of a table.
WEEKDAY Date and Time Returns a number identifying the day of the week of a date. The number is in a range 1-7 or 0-6 according to the choice of the ReturnType parameter.
WEEKNUM Date and Time Returns the week number in the year.
XIRR Financial Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
XNPV Financial Returns the net present value for a schedule of cash flows.
YEAR Date and Time Returns the year of a date as a four digit integer.
YEARFRAC Date and Time Returns the year fraction representing the number of whole days between start_date and end_date.
2018-2021 © SQLBI. All rights are reserved. Information coming from MSDN is property of Microsoft Corp. » Contact us   » Privacy Policy & Cookies

Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

Row Context

This expression is executed in a Row Context. Click to read more.

Iterator

Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

Not recommended

The use of this parameter is not recommended.

Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

Deprecated

This parameter is deprecated and its use is not recommended.

DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

Contribute

Want to improve the content of Latest updates? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.