Power BI

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