Power BI
- Returns a table where all the column names from the {0} provided are prefixed with the given text, {1}, plus a period in ...
- Returns a table which represents the semijoin of two tables supplied and for which the common set of columns are replaced ...
- Returns a table with only those rows of the input table that contain an error in at least one of the cells. If a columns ...
- Returns a table with the list of rows, {2}, inserted into the {0} at the given position, {1}. Each column in the row to insert ...
- Returns a table with the rows removed from the input table that contain an error in at least one of the cells. If a columns ...
- Returns a text value padded to length {1} by inserting spaces at the end of the text value {0}. An optional character {2} ...
- Returns a text value padded to length {1} by inserting spaces at the start of the text value {0}. An optional character {2} ...
- Returns a textual representation in the form "day.hour:mins:sec" of the given duration value, {0}. A text value that specifies ...
- Returns a textual representation of {0}, the Date value, {0}. This function takes in an optional format parameter {1}. For ...
- Returns a textual representation of {0}, the datetime value, {0}. This function takes in an optional format parameter {1}. ...
- Returns a textual representation of {0}, the datetimezone value, {0}. This function takes in an optional format parameter ...
- Returns a textual representation of {0}, the Time value, {0}. This function takes in an optional format parameter {1}. For ...
- Returns a time , datetime , or datetimezone value representing the end of the hour in {0}, including fractional seconds. ...
- Returns a time value from the given {0}. If the given {0} is null , Time.From returns null . If the given {0} is time , {0} ...
- Returns a value generated by rolling up the values of the children of a specified member using the specified unary operator. ...
- Returns a value representing the end of the year in {0}, including fractional seconds. Time zone information is preserved. ...
- Returns a view of {0} where the functions specified in {1} are used in lieu of the default behavior of an operation when ...
- Returns a view of {0} where the functions specified in {1} are used in lieu of the default behavior of an operation when ...
- Returns all messages from the queue specified through MQ.Queue {0} if any messages exist. The read is non-destructive. An ...
- Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been ...
- Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been ...
- Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied inside ...
- Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied inside ...
- Returns databases on an Analysis Services instance, {0}. An optional record parameter, {1}, may be provided to specify additional ...
- Returns formatted text that is created by applying {1} from a list or record to a format string {0}. Optionally, a culture ...
- Returns information about how a table is partitioned. A table is returned where each column is a partition column in the ...
- Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. ...
- Returns one message from the queue specified through MQ.Queue {0} if a message exists. The read is non-destructive. An optional ...
- Returns returns the number of items in a particular path string. This function returns 1 for the path generated for an ID ...
- Returns the absolute value of {0}. If {0} is null, Number.Abs returns null. {0}: A number for which the absolute value is ...
- Returns the absolute value of {0}. If {0} is null, Number.Abs returns null. {0}: Nullable A number for which the absolute ...
- Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle ...
- Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given ...
- Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned ...
- Returns the AST for the body of {0}, normalized into a row expression : The function must be a 1-argument lambda. All references ...
- Returns the average value for the items in the list, {0}. The result is given in the same datatype as the values in the list. ...
- Returns the beta distribution. The beta distribution is commonly used to study variation in the percentage of something across ...
- Returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage ...
- Returns the contents downloaded from {0} as binary. An optional record parameter, {1}, may be provided to specify additional ...
- Returns the contents of the CSV document as a table. {1}: If a record is specified and {2}, {3}, {4} are null, all of parameters ...
- Returns the contents of the CSV document as a table. {1}: If a record is specified and {2}, {3}, {4} are null, all of parameters ...
- Returns the contents of the HTML document broken into its constituent structures, as well as a representation of the full ...
- Returns the current date and time in UTC (the GMT timezone). This value is fixed and will not change with successive calls. ...
- Returns the date , datetime , or datetimezone result from adding {1} days to the datetime value {0}. {0}: The date , datetime ...
- Returns the date , datetime , or datetimezone result from adding {1} months to the datetime value {0}. {0}: The date , datetime ...
- Returns the date , datetime , or datetimezone result from adding {1} quarters to the datetime value {0}. {0}: The date , ...
- Returns the date , datetime , or datetimezone result from adding {1} weeks to the datetime value {0}. {0}: The date , datetime ...
- Returns the date , datetime , or datetimezone result of adding {1} to a datetime value {0}. {0}: The date , datetime , or ...
- Returns the day component of a date , datetime , or datetimezone value. {0}: A date , datetime , or datetimezone value from ...
- Returns the exponential distribution. Use EXPON.DIST to model the time between events, such as how long an automated bank ...
- Returns the first item in the list {0}, or the optional default value, {1}, if the list is empty. If the list is empty and ...
- Returns the first row(s) of the table {0}, depending on the value of {1}: If {1} is a number, that many rows (starting at ...
- Returns the greatest common divisor of two integers. The greatest common divisor is the largest integer that divides both ...
- Returns the integer portion of the result from dividing a number, {0}, by another number, {1}. If {0} or {1} are null, Number.IntegerDivide ...
- Returns the integer portion of the result from dividing a number, {0}, by another number, {1}. If {0} or {1} are null, Number.IntegerDivide ...
- Returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic ...
- Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number, ...
- Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic ...
- Returns the inverse of the beta cumulative probability density function (BETA.DIST). If probability = BETA.DIST(x,.TRUE), ...
- Returns the inverse of the left-tailed probability of the chi-squared distribution. The chi-squared distribution is commonly ...
- Returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHISQ.DIST.RT(x,.), ...
- Returns the item that appears most frequently in the list, {0}. If the list is empty an exception is thrown. If multiple ...
- Returns the items in list {0} that do not appear in list {1}. Duplicate values are supported. An optional equation criteria ...
- Returns the largest numeric value in a column, or the larger value between two scalar expressions. Ignores logical values ...
- Returns the largest numeric value in a column, or the larger value between two scalar expressions. Ignores logical values ...
- Returns the largest row(s) in the {0}, given the {1}. After the rows are sorted, the {2} parameter must be specified to further ...
- Returns the last day of the month in {0}. {0}: A date , datetime , or datetimezone value from which the end of the month ...
- Returns the last day of the week in the provided date , datetime , or datetimezone {0}. This function takes an optional Day ...
- Returns the last item in the list {0}, or the optional default value, {1}, if the list is empty. If the list is empty and ...
- Returns the last item of the list {0}. If the list is empty, an exception is thrown. This function takes an optional parameter, ...
- Returns the last row(s) from the table, {0}, depending on the value of {1}: If {1} is a number, that many rows will be returned ...
- Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple ...
- Returns the logarithm of a number, {0}, to the specified {1} base. If {1} is not specified, the default value is Number.E. ...
- Returns the logarithm of a number, {0}, to the specified {1} base. If {1} is not specified, the default value is Number.E. ...
- Returns the maximum item in the list {0}, or the optional default value {1} if the list is empty. An optional comparisonCriteria ...