Power BI
- Returns a binary format that limits the amount of data that can be read. Both BinaryFormat.List and BinaryFormat.Binary can ...
- Returns a binary format that reads a binary value. If {0} is specified, the binary value will contain that many bytes. If ...
- Returns a binary format that reads a record. The {0} parameter specifies the format of the record. Each field in the record ...
- Returns a binary format that reads a sequence of items and returns a list . The {0} parameter specifies the binary format ...
- Returns a binary format that reads a text value. The {0} specifies the number of bytes to decode, or the binary format of ...
- Returns a binary format that will transform the values read by another binary format. The {0} parameter specifies the binary ...
- Returns a binary value corresponding to the end of {0}. The returned value is always empty (i.e. it is 0 bytes in length). ...
- Returns a binary value from the given {0}. If the given {0} is null , Binary.From returns null . If the given {0} is binary ...
- Returns a comparer function given the {0} and a logical value {1} for case sensitivity for the comparison. The default value ...
- Returns a copy of the text value {0} with all the characters from position {1} removed. An optional parameter, {2} can by ...
- Returns a currency value from the given {0}. If the given {0} is null , Currency.From returns null . If the given {0} is ...
- Returns a date , datetime , or datetimezone value representing the end of the day in {0}. Time zone information is preserved. ...
- Returns a date , datetime , or datetimezone value representing the end of the quarter in {0}. Time zone information is preserved. ...
- 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} ...
- Returns a datetime value from the given {0}. If the given {0} is null , DateTime.From returns null . If the given {0} is ...
- Returns a datetime value set to the current date and time on the system. The returned value contains timezone information ...
- Returns a datetime value set to the current date and time on the system. This value is fixed and will not change with successive ...
- Returns a datetimezone value from the given {0}. If the given {0} is null , DateTimeZone.From returns null . If the given ...
- Returns a datetimezone value set to the current date and time on the system. The returned value contains timezone information ...
- Returns a Decimal number value from the given {0}. If the given {0} is null , Decimal.From returns null . If the given {0} ...
- Returns a Double number value from the given {0}. If the given {0} is null , Double.From returns null . If the given {0} ...
- Returns a duration value from the given {0}. If the given {0} is null , Duration.From returns null . If the given {0} is ...
- Returns a duration value from the specified text, {0}. The following formats can be parsed by this function: (-)hh:mm(:ss(.ff)) ...
- Returns a duration value from the specified text, {0}. The following formats can be parsed by this function: (-)hh:mm(:ss) ...
- Returns a list comprised of all the odd numbered offset elements in a list. Alternates between taking and skipping values ...
- Returns a list of Active Directory domains in the same forest as the specified domain or of the current machine's domain ...
- Returns a list of date values of size {1}, starting at {0}. The given increment, {2}, is a duration value that is added to ...
- Returns a list of datetime values of size {1}, starting at {0}. The given increment, {2}, is a duration value that is added ...
- Returns a list of datetimezone values of size {1}, starting at {0}. The given increment, {2}, is a duration value that is ...
- Returns a list of numbers given an initial value, count, and optional increment value. The default increment value is 1. ...
- Returns a list of offsets for the input list {0}. When using List.Transform to change a list, the list of positions can be ...
- Returns a list of random numbers between 0 and 1, given the number of values to generate and an optional seed value. {0}: ...
- Returns a list of random numbers given the number of values to generate and an optional seed value. {0}: The number of random ...
- Returns a list of text values resulting from the splitting a text value {0} based on any character in the specified delimiter, ...
- Returns a list of time values of size {1}, starting at {0}. The given increment, {2}, is a duration value that is added to ...
- Returns a list that contains all the values in list {0} with duplicates removed. If the list is empty, the result is an empty ...
- Returns a list that removes the first element of list {0}. If {0} is an empty list an empty list is returned. This function ...
- 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 ...
- Returns a list that skips the first element of list {0}. If {0} is an empty list an empty list is returned. This function ...
- Returns a list whose elements are projected from the input list. The collectionTransform function is applied to each element, ...
- Returns a logical value based on the equality check over the two given values, {1} and {2}, using the provided {0}. {0} is ...
- Returns a logical value from the given {0}. If the given {0} is null , Logical.From returns null . If the given {0} is logical ...
- Returns a logical value whether there are duplicates in the list {0}; true if the list is distinct, false if there are duplicate ...
- Returns a navigational table containing a row for each container found at the account URL, {0}, from an Azure storage vault. ...
- Returns a navigational table containing a row for each table found at the account URL, {0}, from an Azure storage vault. ...
- Returns a nested tree of tables representing the display folder hierarchy of the objects (e.g. dimensions and measures) available ...
- 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. ...
- Returns a number between 0 and 6 representing the day of the week in the provided datetime value {0}. This function takes ...
- Returns a number between 0 and 6 representing the day of the week in the provided datetime value {0}. This function takes ...
- 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 ...
- 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 ...
- Returns a number from 1 to 54 indicating which week of the year the date, {0}, falls in. {0}: A datetime value for which ...
- Returns a number value from the given text value, {0}. {0}: The textual representation of a number value. The representation ...
- Returns a number value from the given {0}. If the given {0} is null , Number.From returns null . If the given {0} is number ...
- Returns a one column table that contains the distinct (unique) values in a column, for a column argument. Or multiple columns ...
- Returns a profile for the columns in {0}. The following information is returned for each column (when applicable): minimum ...
- Returns a random number greater than or equal to 0 and less than 1, evenly distributed. Random numbers change on recalculation. ...
- Returns a record after applying transformations specified in list {1} to {0}. One or more fields may be transformed at a ...
- Returns a record after renaming fields in the input {0} to the new field names specified in list {1}. For multiple renames, ...
- Returns a record after reordering the fields in {0} in the order of fields specified in list {1}. Field values are maintained ...
- Returns a record containing the parts of the given date value, {0}. {0}: A date value for from which the record of its parts ...
- Returns a record containing the parts of the given datetime value, {0}. {0}: A datetime value for from which the record of ...
- Returns a record containing the parts of the given datetimezone value, {0}. {0}: A datetimezone value for from which the ...
- Returns a record containing the parts of the given Time value, {0}. {0}: A time value for from which the record of its parts ...
- Returns a record describing the fields of a record type with each field of the returned record type having a corresponding ...
- Returns a record describing the fields of a record {0}. Each field of the returned record type has a corresponding name and ...
- Returns a record from a table of records {0} containing field names and value names {[Name = name, Value = value]} . An exception ...
- 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, ...
- Returns a record that removes all the fields specified in list {1} from the input {0}. If the field specified does not exist, ...
- Returns a record with field values set to the name of the parameters of a function type, and their values set to their corresponding ...
- Returns a record with field values set to the name of the parameters of {0}, and their values set to their corresponding ...
- Returns a sample based estimate of the standard deviation of the values in the list, {0}. If {0} is a list of numbers, a ...
- Returns a sample based estimate of the standard deviation of the values in the list, {0}. If {0} is a list of numbers, a ...
- Returns a set generated by dynamically totaling child members in a specified set, optionally using a pattern for the name ...
- Returns a set of members (periods) from a specified level starting with the first member and ending with a specified member. ...