Power BI
- Returns the maximum value(s) in the list, {0}. After the rows are sorted, optional parameters may be specified to further ...
- Returns the median item of the list {0}. This function throws an exception if the list is empty. If there is an even number ...
- Returns the member that is a specified number of positions following a specified member along the dimension of the member. ...
- Returns the member that is a specified number of positions prior to a specified member along the dimension of the member. ...
- Returns the minimum item in the list {0}, or the optional default value {1} if the list is empty. An optional comparisonCriteria ...
- Returns the minimum value(s) in the list, {0}. The parameter, {1}, specifies the number of values to return or a filtering ...
- Returns the nth item in the delimited list produced by the Path function, counting backwards from the last item in the path ...
- Returns the nth item in the delimited list produced by the Path function, counting backwards from the last item in the path. ...
- Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups ...
- Returns the number of days in the month in the date , datetime , or datetimezone value {0}. {0}: A date , datetime , or datetimezone ...
- Returns the number of permutations for a given number of objects that can be selected from number objects. A permutation ...
- Returns the number of permutations that can be generated from a number of items, {0}, with a specified permutation size, ...
- Returns the number of unique combinations from a list of items, {0} with specified combination size, {1}. {0}: The number ...
- Returns the objects on the Salesforce account provided in the credentials. The account will be connected through the provided ...
- Returns the offset at which the value {1} appears in the list {0}. Returns -1 if the value doesn't appear. An optional occurrence ...
- Returns the offset in list {0} of the first occurrence of a value in a list {1}. Returns -1 if no occurrence is found. An ...
- Returns the parts of the input {0} as a record, containing values such as Scheme, Host, Port, Path, Query, Fragment, UserName ...
- Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over ...
- Returns the position of the first occurrence of any of the characters in the character list {0} found in the text value {1}. ...
- Returns the position of the specified occurrence of the text value {1} found in {0}. An optional parameter {2} may be used ...
- Returns the product of multiplying {0} by {1}. An optional {2} parameter may be specified, by default Precision.Double is ...
- Returns the product of the numbers in the given {1} of the {0}. If the column does not contain number values, an exception ...
- 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 ...
- 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 ...
- Returns the rank of a specified tuple within a specified set, where the rank is based on the position of the tuple within ...
- Returns the rank of a specified tuple within a specified set, with the rank determined by the value of a specified numeric ...
- Returns the rank of an expression evaluated in the current context in the list of values for the expression evaluated for ...
- Returns the rank of an expression evaluated in the current context in the list of values for the expression evaluated for ...
- Returns the remainder resulting from the integer division of {0} by {1}. If {0} or {1} are null, Number.Mod returns null. ...
- Returns the remainder resulting from the integer division of {0} by {1}. If {0} or {1} are null, Number.Mod returns null. ...
- Returns the reports on the Salesforce account provided in the credentials. The account will be connected through the provided ...
- Returns the result of capitalizing only the first letter of each word in text value {0}. All other letters are returned in ...
- Returns the result of combining the list of text values, {0}, into a single text value. An optional separator used in the ...
- Returns the result of converting a binary list of numbers {0} into a text value. Optionally, {1} may be specified to indicate ...
- Returns the result of converting text value {0} to a binary (list of number ). {1} may be specified to indicate the encoding ...
- Returns the result of dividing {0} by {1}. An optional {2} parameter may be specified, by default Precision.Double is used. ...
- Returns the result of raising e to the power of {0} (exponential function). {0}: A number for which the exponential function ...
- Returns the result of raising e to the power of {0} (exponential function). {0}: Nullable A number for which the exponential ...
- Returns the result of raising {0} to the power of {1}. If {0} or {1} are null, Number.Power returns null. {0}: Nullable The ...
- Returns the result of raising {0} to the power of {1}. If {0} or {1} are null, Number.Power returns null. {0}: The base. ...
- Returns the result of removing a number of characters, {2}, from text value {0} beginning at position {1} and then inserting ...
- Returns the result of replacing all occurrences of text value {1} in text value {0} with text value {2}. This function is ...
- Returns the result of rounding {0} based on the sign of the number. This function will round positive numbers down and negative ...
- Returns the result of rounding {0} based on the sign of the number. This function will round positive numbers up and negative ...
- Returns the result of rounding {0} down to the previous highest integer. If {0} is null, Number.RoundDown returns null. If ...
- Returns the result of rounding {0} down to the previous highest integer. If {0} is null, Number.RoundDown returns null. If ...
- Returns the result of rounding {0} to the nearest number. If {0} is null, Number.Round returns null. {0} is rounded to the ...
- Returns the result of rounding {0} to the nearest number. If {0} is null, Number.Round returns null. {0} is rounded to the ...
- Returns the result of running {1} with the connection string {0} using ODBC. {0} can be text or a record of property value ...
- Returns the result of running {1} with the connection string {0} using OLE DB. {0} can be text or a record of property value ...
- Returns the result of running {2} with the connection string {1} using the ADO.NET provider {0}. {1} can be text or a record ...
- Returns the right-tailed probability of the chi-squared distribution. The chi-squared distribution is associated with a chi-squared ...
- Returns the row position of the first occurrence of the {1} in the {0} specified. Returns -1 if no occurrence is found. {0}: ...
- Returns the row(s) position(s) from the {0} of the first occurrence of the list of {1}. Returns -1 if no occurrence is found. ...
- Returns the rows from the {0} starting at the specified {1}. An optional parameter, {2}, specifies how many rows to return. ...
- Returns the schema collection for the ADO.NET data source with provider name {0} and connection string {1}. {1} can be text ...
- Returns the set of descendants of a member at a specific distance away in the hierarchy, optionally including or excluding ...
- Returns the set of descendants of a member at a specified level, optionally including or excluding descendants in other levels. ...
- Returns the smallest numeric value in a column, or the smaller value between two scalar expressions. Ignores logical values ...
- Returns the smallest numeric value in a column, or the smaller value between two scalar expressions. Ignores logical values ...
- Returns the smallest row(s) in the {0}, given the {1}. After the rows are sorted, the {2} parameter must be specified to ...
- Returns the square root of {0}. If {0} is null, Number.Sqrt returns null. If it is a negative value, Number.NaN is returned ...
- Returns the standard deviation of a numeric expression evaluated over a set, using a biased population. (Alias for StdevP.) ...
- Returns the standard deviation of a numeric expression evaluated over a set, using an unbiased population. (Alias for Stdev.) ...
- Returns the string {0} from the current extension MEZ file localized for the current culture, falling back to the default ...
- Returns the substring from the text {0} found at the offset {1}. An optional parameter, {2}, can be included to specify how ...
- Returns the text representation of {0}. The {0} can be a number , date , time , datetime , datetimezone , logical , duration ...
- Returns the union of a list of types {0}. An optional {1} parameter may be used to specify behaviour for missing columns ...
- Returns the variance of a numeric expression evaluated over a set, using an unbiased population. (Alias for Var function.) ...
- Returns the {0} with only the specified {1}. {0}: The provided table. {1}: The list of columns from the table {0} to return. ...
- Returns true if a connection to {0}'s data source can be established or an error otherwise. Will not run or demand permissions ...
- Returns true if text value {0} starts with text value {1}, false otherwise. {0}: A text value which is to be searched {1}: ...
- Returns true if text value {0} starts with text value {1}. {0}: A text value which is to be searched {1}: A text value which ...
- Returns universes on an SapBusinessObjects BI service, {0}. An optional record parameter, {1}, may be provided to specify ...
- Right outer joins return all rows from the right table, and all rows from the left table where the joined fields match in ...