Power BI

  1. Returns a table where all the column names from the {0} provided are prefixed with the given text, {1}, plus a period in ...
  2. Returns a table which represents the semijoin of two tables supplied and for which the common set of columns are replaced ...
  3. 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 ...
  4. 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 ...
  5. 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 ...
  6. Returns a text value padded to length {1} by inserting spaces at the end of the text value {0}. An optional character {2} ...
  7. Returns a text value padded to length {1} by inserting spaces at the start of the text value {0}. An optional character {2} ...
  8. Returns a textual representation in the form "day.hour:mins:sec" of the given duration value, {0}. A text value that specifies ...
  9. Returns a textual representation of {0}, the Date value, {0}. This function takes in an optional format parameter {1}. For ...
  10. Returns a textual representation of {0}, the datetime value, {0}. This function takes in an optional format parameter {1}. ...
  11. Returns a textual representation of {0}, the datetimezone value, {0}. This function takes in an optional format parameter ...
  12. Returns a textual representation of {0}, the Time value, {0}. This function takes in an optional format parameter {1}. For ...
  13. Returns a time , datetime , or datetimezone value representing the end of the hour in {0}, including fractional seconds. ...
  14. 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} ...
  15. Returns a value generated by rolling up the values of the children of a specified member using the specified unary operator. ...
  16. Returns a value representing the end of the year in {0}, including fractional seconds. Time zone information is preserved. ...
  17. Returns a view of {0} where the functions specified in {1} are used in lieu of the default behavior of an operation when ...
  18. Returns a view of {0} where the functions specified in {1} are used in lieu of the default behavior of an operation when ...
  19. Returns all messages from the queue specified through MQ.Queue {0} if any messages exist. The read is non-destructive. An ...
  20. Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been ...
  21. Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been ...
  22. Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied inside ...
  23. Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied inside ...
  24. Returns databases on an Analysis Services instance, {0}. An optional record parameter, {1}, may be provided to specify additional ...
  25. Returns formatted text that is created by applying {1} from a list or record to a format string {0}. Optionally, a culture ...
  26. Returns information about how a table is partitioned. A table is returned where each column is a partition column in the ...
  27. Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. ...
  28. Returns one message from the queue specified through MQ.Queue {0} if a message exists. The read is non-destructive. An optional ...
  29. Returns returns the number of items in a particular path string. This function returns 1 for the path generated for an ID ...
  30. Returns the absolute value of {0}. If {0} is null, Number.Abs returns null. {0}: A number for which the absolute value is ...
  31. Returns the absolute value of {0}. If {0} is null, Number.Abs returns null. {0}: Nullable A number for which the absolute ...
  32. Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle ...
  33. Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given ...
  34. Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned ...
  35. Returns the AST for the body of {0}, normalized into a row expression : The function must be a 1-argument lambda. All references ...
  36. 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. ...
  37. Returns the beta distribution. The beta distribution is commonly used to study variation in the percentage of something across ...
  38. Returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage ...
  39. Returns the contents downloaded from {0} as binary. An optional record parameter, {1}, may be provided to specify additional ...
  40. 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 ...
  41. 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 ...
  42. Returns the contents of the HTML document broken into its constituent structures, as well as a representation of the full ...
  43. Returns the current date and time in UTC (the GMT timezone). This value is fixed and will not change with successive calls. ...
  44. Returns the date , datetime , or datetimezone result from adding {1} days to the datetime value {0}. {0}: The date , datetime ...
  45. Returns the date , datetime , or datetimezone result from adding {1} months to the datetime value {0}. {0}: The date , datetime ...
  46. Returns the date , datetime , or datetimezone result from adding {1} quarters to the datetime value {0}. {0}: The date , ...
  47. Returns the date , datetime , or datetimezone result from adding {1} weeks to the datetime value {0}. {0}: The date , datetime ...
  48. Returns the date , datetime , or datetimezone result of adding {1} to a datetime value {0}. {0}: The date , datetime , or ...
  49. Returns the day component of a date , datetime , or datetimezone value. {0}: A date , datetime , or datetimezone value from ...
  50. Returns the exponential distribution. Use EXPON.DIST to model the time between events, such as how long an automated bank ...
  51. 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 ...
  52. 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 ...
  53. Returns the greatest common divisor of two integers. The greatest common divisor is the largest integer that divides both ...
  54. Returns the integer portion of the result from dividing a number, {0}, by another number, {1}. If {0} or {1} are null, Number.IntegerDivide ...
  55. Returns the integer portion of the result from dividing a number, {0}, by another number, {1}. If {0} or {1} are null, Number.IntegerDivide ...
  56. Returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic ...
  57. Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number, ...
  58. Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic ...
  59. Returns the inverse of the beta cumulative probability density function (BETA.DIST). If probability = BETA.DIST(x,.TRUE), ...
  60. Returns the inverse of the left-tailed probability of the chi-squared distribution. The chi-squared distribution is commonly ...
  61. Returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHISQ.DIST.RT(x,.), ...
  62. Returns the item that appears most frequently in the list, {0}. If the list is empty an exception is thrown. If multiple ...
  63. Returns the items in list {0} that do not appear in list {1}. Duplicate values are supported. An optional equation criteria ...
  64. Returns the largest numeric value in a column, or the larger value between two scalar expressions. Ignores logical values ...
  65. Returns the largest numeric value in a column, or the larger value between two scalar expressions. Ignores logical values ...
  66. Returns the largest row(s) in the {0}, given the {1}. After the rows are sorted, the {2} parameter must be specified to further ...
  67. Returns the last day of the month in {0}. {0}: A date , datetime , or datetimezone value from which the end of the month ...
  68. Returns the last day of the week in the provided date , datetime , or datetimezone {0}. This function takes an optional Day ...
  69. 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 ...
  70. Returns the last item of the list {0}. If the list is empty, an exception is thrown. This function takes an optional parameter, ...
  71. 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 ...
  72. Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple ...
  73. Returns the logarithm of a number, {0}, to the specified {1} base. If {1} is not specified, the default value is Number.E. ...
  74. Returns the logarithm of a number, {0}, to the specified {1} base. If {1} is not specified, the default value is Number.E. ...
  75. Returns the maximum item in the list {0}, or the optional default value {1} if the list is empty. An optional comparisonCriteria ...