Power BI

  1. Returns a binary format that limits the amount of data that can be read. Both BinaryFormat.List and BinaryFormat.Binary can ...
  2. Returns a binary format that reads a binary value. If {0} is specified, the binary value will contain that many bytes. If ...
  3. Returns a binary format that reads a record. The {0} parameter specifies the format of the record. Each field in the record ...
  4. Returns a binary format that reads a sequence of items and returns a list . The {0} parameter specifies the binary format ...
  5. Returns a binary format that reads a text value. The {0} specifies the number of bytes to decode, or the binary format of ...
  6. Returns a binary format that will transform the values read by another binary format. The {0} parameter specifies the binary ...
  7. Returns a binary value corresponding to the end of {0}. The returned value is always empty (i.e. it is 0 bytes in length). ...
  8. Returns a binary value from the given {0}. If the given {0} is null , Binary.From returns null . If the given {0} is binary ...
  9. Returns a comparer function given the {0} and a logical value {1} for case sensitivity for the comparison. The default value ...
  10. Returns a copy of the text value {0} with all the characters from position {1} removed. An optional parameter, {2} can by ...
  11. Returns a currency value from the given {0}. If the given {0} is null , Currency.From returns null . If the given {0} is ...
  12. Returns a date , datetime , or datetimezone value representing the end of the day in {0}. Time zone information is preserved. ...
  13. Returns a date , datetime , or datetimezone value representing the end of the quarter in {0}. Time zone information is preserved. ...
  14. Returns a date value from the given {0}. If the given {0} is null , Date.From returns null . If the given {0} is date , {0} ...
  15. Returns a datetime value from the given {0}. If the given {0} is null , DateTime.From returns null . If the given {0} is ...
  16. Returns a datetime value set to the current date and time on the system. The returned value contains timezone information ...
  17. Returns a datetime value set to the current date and time on the system. This value is fixed and will not change with successive ...
  18. Returns a datetimezone value from the given {0}. If the given {0} is null , DateTimeZone.From returns null . If the given ...
  19. Returns a datetimezone value set to the current date and time on the system. The returned value contains timezone information ...
  20. Returns a Decimal number value from the given {0}. If the given {0} is null , Decimal.From returns null . If the given {0} ...
  21. Returns a Double number value from the given {0}. If the given {0} is null , Double.From returns null . If the given {0} ...
  22. Returns a duration value from the given {0}. If the given {0} is null , Duration.From returns null . If the given {0} is ...
  23. Returns a duration value from the specified text, {0}. The following formats can be parsed by this function: (-)hh:mm(:ss(.ff)) ...
  24. Returns a duration value from the specified text, {0}. The following formats can be parsed by this function: (-)hh:mm(:ss) ...
  25. Returns a list comprised of all the odd numbered offset elements in a list. Alternates between taking and skipping values ...
  26. Returns a list of Active Directory domains in the same forest as the specified domain or of the current machine's domain ...
  27. Returns a list of date values of size {1}, starting at {0}. The given increment, {2}, is a duration value that is added to ...
  28. Returns a list of datetime values of size {1}, starting at {0}. The given increment, {2}, is a duration value that is added ...
  29. Returns a list of datetimezone values of size {1}, starting at {0}. The given increment, {2}, is a duration value that is ...
  30. Returns a list of numbers given an initial value, count, and optional increment value. The default increment value is 1. ...
  31. Returns a list of offsets for the input list {0}. When using List.Transform to change a list, the list of positions can be ...
  32. Returns a list of random numbers between 0 and 1, given the number of values to generate and an optional seed value. {0}: ...
  33. Returns a list of random numbers given the number of values to generate and an optional seed value. {0}: The number of random ...
  34. Returns a list of text values resulting from the splitting a text value {0} based on any character in the specified delimiter, ...
  35. Returns a list of time values of size {1}, starting at {0}. The given increment, {2}, is a duration value that is added to ...
  36. Returns a list that contains all the values in list {0} with duplicates removed. If the list is empty, the result is an empty ...
  37. Returns a list that removes the first element of list {0}. If {0} is an empty list an empty list is returned. This function ...
  38. Returns a list that removes the last {1} elements from the end of list {0}. If {0} has less than {1} elements, an empty list ...
  39. Returns a list that skips the first element of list {0}. If {0} is an empty list an empty list is returned. This function ...
  40. Returns a list whose elements are projected from the input list. The collectionTransform function is applied to each element, ...
  41. Returns a logical value based on the equality check over the two given values, {1} and {2}, using the provided {0}. {0} is ...
  42. Returns a logical value from the given {0}. If the given {0} is null , Logical.From returns null . If the given {0} is logical ...
  43. Returns a logical value whether there are duplicates in the list {0}; true if the list is distinct, false if there are duplicate ...
  44. Returns a navigational table containing a row for each container found at the account URL, {0}, from an Azure storage vault. ...
  45. Returns a navigational table containing a row for each table found at the account URL, {0}, from an Azure storage vault. ...
  46. Returns a nested tree of tables representing the display folder hierarchy of the objects (e.g. dimensions and measures) available ...
  47. Returns a new list produced by inserting the values in {2} into {0} at {1}. The first position in the list is at index 0. ...
  48. Returns a number between 0 and 6 representing the day of the week in the provided datetime value {0}. This function takes ...
  49. Returns a number between 0 and 6 representing the day of the week in the provided datetime value {0}. This function takes ...
  50. Returns a number from 1 to 4 indicating which quarter of the year the date {0} falls in. {0} can be a date , datetime , or ...
  51. Returns a number from 1 to 5 indicating which week of the year month the date {0} falls in. {0}: A datetime value for which ...
  52. Returns a number from 1 to 54 indicating which week of the year the date, {0}, falls in. {0}: A datetime value for which ...
  53. Returns a number value from the given text value, {0}. {0}: The textual representation of a number value. The representation ...
  54. Returns a number value from the given {0}. If the given {0} is null , Number.From returns null . If the given {0} is number ...
  55. Returns a one column table that contains the distinct (unique) values in a column, for a column argument. Or multiple columns ...
  56. Returns a profile for the columns in {0}. The following information is returned for each column (when applicable): minimum ...
  57. Returns a random number greater than or equal to 0 and less than 1, evenly distributed. Random numbers change on recalculation. ...
  58. Returns a record after applying transformations specified in list {1} to {0}. One or more fields may be transformed at a ...
  59. Returns a record after renaming fields in the input {0} to the new field names specified in list {1}. For multiple renames, ...
  60. Returns a record after reordering the fields in {0} in the order of fields specified in list {1}. Field values are maintained ...
  61. Returns a record containing the parts of the given date value, {0}. {0}: A date value for from which the record of its parts ...
  62. Returns a record containing the parts of the given datetime value, {0}. {0}: A datetime value for from which the record of ...
  63. Returns a record containing the parts of the given datetimezone value, {0}. {0}: A datetimezone value for from which the ...
  64. Returns a record containing the parts of the given Time value, {0}. {0}: A time value for from which the record of its parts ...
  65. Returns a record describing the fields of a record type with each field of the returned record type having a corresponding ...
  66. Returns a record describing the fields of a record {0}. Each field of the returned record type has a corresponding name and ...
  67. Returns a record from a table of records {0} containing field names and value names {[Name = name, Value = value]} . An exception ...
  68. Returns a record given a {0} of field values and a set of fields. The {1} can be specified either by a list of text values, ...
  69. Returns a record that removes all the fields specified in list {1} from the input {0}. If the field specified does not exist, ...
  70. Returns a record with field values set to the name of the parameters of a function type, and their values set to their corresponding ...
  71. Returns a record with field values set to the name of the parameters of {0}, and their values set to their corresponding ...
  72. Returns a sample based estimate of the standard deviation of the values in the list, {0}. If {0} is a list of numbers, a ...
  73. Returns a sample based estimate of the standard deviation of the values in the list, {0}. If {0} is a list of numbers, a ...
  74. Returns a set generated by dynamically totaling child members in a specified set, optionally using a pattern for the name ...
  75. Returns a set of members (periods) from a specified level starting with the first member and ending with a specified member. ...