Welcome to our updated articles section. Here, you’ll find the most recent updates and additions to our Power Query M language function documentation, neatly organized for your convenience. This section is divided into several categories for easy navigation:
- New Additions: Keep an eye out for items labelled as
new. These represent the latest pages that have been added to our website to make sure you can make use of the latest functions right away. - Updated Content: All other categories concern existing content that has received updates or revisions. These have categories such as
Functions,Enumerations, andPages.
Use this page to stay up-to-date with the Power Query M language functions and to keep track of updated articles.
November 2023
| Name | Category | Description | Last update |
|---|---|---|---|
| List.PositionOfAny | Functions | Returns the first offset of a value in a list. | Nov 28, 2023 |
| List.ReplaceMatchingItems | Functions | Applies each replacement of { old, new }. | Nov 28, 2023 |
| List.ReplaceRange | Functions | Replaces count number of values starting at position with the replacement values. | Nov 28, 2023 |
| List.ReplaceValue | Functions | Searches a list for the specified value and replaces it. | Nov 28, 2023 |
| List.Transform | Functions | Returns a new list of values computed from this list. | Nov 28, 2023 |
| List.TransformMany | Functions | Returns a list whose elements are transformed from the input list using specified functions. | Nov 28, 2023 |
| Action.WithErrorContext | New | This function is intended for internal use only. | Nov 24, 2023 |
| AzureDataFactory.Actions | New | Connect to Azure Data Factory Service | Nov 24, 2023 |
| AzureDatabricksWorkspace.Actions | New | Connect to Azure Databricks workspace | Nov 24, 2023 |
| AzureKeyVault.Actions | New | Connect to Azure Keyvault Service | Nov 24, 2023 |
| AzureResourceGraph.Query | New | Nov 24, 2023 | |
| AzureSynapseWorkspace.Actions | New | Connect to Azure Synapse Service | Nov 24, 2023 |
| AzureTrino.Contents | New | Nov 24, 2023 | |
| DremioCloud.DatabasesByServerV360 | New | Returns a table listing the datasets on the specified server on Dremio Cloud | Nov 24, 2023 |
| EmplifiMetrics.Contents | New | Nov 24, 2023 | |
| Function.InvokeWithErrorContext | New | This function is intended for internal use only. | Nov 24, 2023 |
| IoTHub.Contents | New | Used to connect to Azure IoT Hub. | Nov 24, 2023 |
| MongoDBAtlasForPipeline.Database | New | Connect to MongoDB Atlas For Pipeline | Nov 24, 2023 |
| MongoDBForPipeline.Contents | New | Used to connect to MongoDB For Pipeline. | Nov 24, 2023 |
| Parquet.Metadata | New | This function is intended for internal use only. | Nov 24, 2023 |
| PlanviewOKR.Contents | New | Enter the URL of your Planview OKR account. | Nov 24, 2023 |
| PowerBIDatasets.Actions | New | Connect to PowerBIDatasets | Nov 24, 2023 |
| Table.WithErrorContext | New | This function is intended for internal use only. | Nov 24, 2023 |
| Table.AddRankColumn | Functions | Appends a column with the ranking of one or more other columns. | Nov 18, 2023 |
| Table.Buffer | Functions | Buffers a table in memory, isolating it from external changes during evaluation. | Nov 18, 2023 |
| Type.IsNullable | Functions | Returns true if a type is a nullable type; otherwise, false. | Nov 15, 2023 |
| Type.IsOpenRecord | Functions | Returns whether a record type is open. | Nov 15, 2023 |
| Type.ListItem | Functions | Returns an item type from a list type. | Nov 15, 2023 |
| Type.NonNullable | Functions | Returns the non nullable type from a type. | Nov 15, 2023 |
| Type.OpenRecord | Functions | Returns an opened version of the given record type (or the same type, if it is already open). | Nov 15, 2023 |
| Type.RecordFields | Functions | Returns a record describing the fields of a record type with each field of the returned record type having a corresponding name and a value. | Nov 15, 2023 |
| Type.ReplaceTableKeys | Functions | Returns a new table type with all keys replaced by the specified list of keys. | Nov 15, 2023 |
| Type.TableColumn | Functions | Returns the type of a column in a table. | Nov 15, 2023 |
| Type.TableKeys | Functions | Returns the possibly empty list of keys for the given table type. | Nov 15, 2023 |
| Type.TableRow | Functions | Returns the row type of the table type. | Nov 15, 2023 |
| Type.TableSchema | Functions | Returns a table containing a description of the columns (i.e | Nov 15, 2023 |
| Type.Union | Functions | Returns the union of a list of types. | Nov 15, 2023 |
| Type.ReplaceFacets | Functions | Replaces the facets of a type. | Nov 13, 2023 |
| Type.AddTableKey | Functions | Adds a key to the given table type. | Nov 11, 2023 |
| Type.ClosedRecord | Functions | Returns a closed version of the given record type (or the same type, if it is already closed). | Nov 11, 2023 |
| Type.Facets | Functions | Returns the facets of a type. | Nov 11, 2023 |
| Type.ForFunction | Functions | Returns a type that represents functions with specific parameter and return type constraints. | Nov 11, 2023 |
| Type.ForRecord | Functions | Returns a type that represents records with specific type constraints on fields. | Nov 11, 2023 |
| Type.FunctionParameters | Functions | Returns a record with field values set to the name of the parameters of a function type, and their values set to their corresponding types. | Nov 11, 2023 |
| Type.FunctionRequiredParameters | Functions | Returns a number indicating the minimum number of parameters required to invoke the type of function. | Nov 11, 2023 |
| Type.FunctionReturn | Functions | Returns a type returned by a function type. | Nov 11, 2023 |
| Type.Is | Functions | Determines if a value of the first type is always compatible with the second type. | Nov 11, 2023 |
October 2023
| Name | Category | Description | Last update |
|---|---|---|---|
| Combiner.CombineTextByLengths | Functions | Returns a function that combines a list of text into a single text using the specified lengths. | Oct 30, 2023 |
| Date.FromText | Functions | Creates a Date from local, universal, and custom Date formats. | Oct 28, 2023 |
| DateTime.FromText | Functions | Creates a datetimezone from local and universal datetime formats. | Oct 28, 2023 |
| Comparer.FromCulture | Functions | Returns a comparer function given the culture and a logical value for case sensitivity for the comparison. | Oct 27, 2023 |
| Date.ToText | Functions | Returns a textual representation of the date value. | Oct 25, 2023 |
| DateTime.ToText | Functions | Returns a textual representation of the datetime value. | Oct 25, 2023 |
| DateTimeZone.ToText | Functions | Returns a textual representation of the datetimezone value. | Oct 25, 2023 |
| Number.ToText | Functions | Formats the given number as text. | Oct 25, 2023 |
| Time.ToText | Functions | Returns a textual representation of the time value. | Oct 25, 2023 |
| Table.ReplaceValue | Functions | Replaces one value with another in the specified columns. | Oct 23, 2023 |
| List.FirstN | Functions | Returns the first set of items in the list by specifying how many items to return or a qualifying condition. | Oct 20, 2023 |
| Table.ExpandRecordColumn | Functions | Expands a column of records into columns with each of the values. | Oct 20, 2023 |
September 2023
| Name | Category | Description | Last update |
|---|---|---|---|
| Combiner.CombineTextByPositions | Functions | Returns a function that combines a list of text into a single text using the specified positions. | Sep 22, 2023 |
| Combiner.CombineTextByRanges | Functions | Returns a function that combines a list of text into a single text using the specified positions and lengths. | Sep 22, 2023 |
| Sql.Database | Functions | Returns a table of SQL tables, views, and stored functions from the SQL Server database. | Sep 20, 2023 |
| Table.StopFolding | Functions | Prevents any downstream operations from being run against the original source of the data. | Sep 20, 2023 |
| Value.NativeQuery | Functions | Evaluates a query against a target. | Sep 20, 2023 |
| WebMethod.Delete | Enumerations | Specifies the DELETE method for HTTP. | Sep 20, 2023 |
| WebMethod.Get | Enumerations | Specifies the GET method for HTTP. | Sep 20, 2023 |
| WebMethod.Head | Enumerations | Specifies the HEAD method for HTTP. | Sep 20, 2023 |
| WebMethod.Patch | Enumerations | Specifies the PATCH method for HTTP. | Sep 20, 2023 |
| WebMethod.Post | Enumerations | Specifies the POST method for HTTP. | Sep 20, 2023 |
| WebMethod.Put | Enumerations | Specifies the PUT method for HTTP. | Sep 20, 2023 |
| LimitClauseKind.AnsiSql2008 | Enumerations | This SQL dialect supports an ANSI SQL-compatible LIMIT N ROWS specifier to limit the number of rows returned. | Sep 13, 2023 |
| LimitClauseKind.Limit | Enumerations | This SQL dialect supports a LIMIT specifier to limit the number of rows returned. | Sep 13, 2023 |
| LimitClauseKind.LimitOffset | Enumerations | This SQL dialect supports LIMIT and OFFSET specifiers to limit the number of rows returned. | Sep 13, 2023 |
| LimitClauseKind.None | Enumerations | This SQL dialect does not support a limit clause. | Sep 13, 2023 |
| LimitClauseKind.Top | Enumerations | This SQL dialect supports a TOP specifier to limit the number of rows returned. | Sep 13, 2023 |
| List.InsertRange | Functions | Inserts values into a list at the given index. | Sep 12, 2023 |
| List.Union | Functions | Returns the union of the list values found in the input. | Sep 6, 2023 |
| List.Combine | Functions | Returns a single list by combining multiple lists. | Sep 5, 2023 |
| Guid.From | Functions | Returns a guid value from the given value. | Sep 4, 2023 |
August 2023
| Name | Category | Description | Last update |
|---|---|---|---|
| List.PositionOf | Functions | Returns the offset(s) of a value in a list. | Aug 30, 2023 |
| Table.TransformColumns | Functions | Transforms the values of one or more columns. | Aug 30, 2023 |
| List.Difference | Functions | Returns the difference of the two given lists. | Aug 29, 2023 |
| List.Distinct | Functions | Returns a list of values with duplicates removed. | Aug 29, 2023 |
| List.RemoveNulls | Functions | Removes all “null” values from the specified list. | Aug 29, 2023 |
| List.RemoveRange | Functions | Removes count number of values starting at the specified position. | Aug 29, 2023 |
| List.Skip | Functions | Returns a list that skips the specified number of elements at the beginning of the list. | Aug 29, 2023 |
| List.Intersect | Functions | Returns the intersection of the list values found in the input. | Aug 28, 2023 |
| List.RemoveItems | Functions | Removes items from list1 that are present in list. | Aug 28, 2023 |
| List.RemoveMatchingItems | Functions | Removes all occurrences of the input values. | Aug 28, 2023 |
| List.Last | Functions | Returns the last value of the list or the specified default if empty. | Aug 27, 2023 |
| List.LastN | Functions | Returns the last value in the list | Aug 27, 2023 |
| List.Max | Functions | Returns the maximum value or the default value for an empty list. | Aug 27, 2023 |
| List.MaxN | Functions | Returns the maximum value(s) in the list | Aug 27, 2023 |
| List.Min | Functions | Returns the minimum value or the default value for an empty list. | Aug 27, 2023 |
| List.MinN | Functions | Returns the minimum value(s) in the list | Aug 27, 2023 |
| List.Range | Functions | Returns a subset of the list beginning at an offset. | Aug 27, 2023 |
| List.RemoveFirstN | Functions | Returns a list that skips the specified number of elements at the beginning of the list. | Aug 27, 2023 |
| List.RemoveLastN | Functions | Returns a list that removes the specified number of elements from the end of the list. | Aug 27, 2023 |
| List.First | Functions | Returns the first value of the list or the specified default if empty. | Aug 25, 2023 |
| List.Numbers | Functions | Returns a list of numbers given an initial value, count, and optional increment value. | Aug 25, 2023 |
| List.Random | Functions | Returns a list of random numbers. | Aug 25, 2023 |
| List.Repeat | Functions | Returns a list that is count repetitions of the original list. | Aug 25, 2023 |
| List.Split | Functions | Splits the specified list into a list of lists using the specified page size. | Aug 25, 2023 |
| List.Zip | Functions | Returns a list of lists by combining items at the same position in multiple lists. | Aug 25, 2023 |
| Diagnostics.ActivityId | Functions | Returns an opaque identifier for the currently-running evaluation. | Aug 24, 2023 |
| Diagnostics.Trace | Functions | Writes a trace entry, if tracing is enabled, and returns the value. | Aug 24, 2023 |
| Error.Record | Functions | Returns an error record from the provided text values for reason, message and detail. | Aug 24, 2023 |
| List.Reverse | Functions | Reverses the order of values in the list. | Aug 24, 2023 |
| TraceLevel.Critical | Enumerations | Specifies Critical trace level. | Aug 24, 2023 |
| TraceLevel.Error | Enumerations | Specifies Error trace level. | Aug 24, 2023 |
| TraceLevel.Information | Enumerations | Specifies Information trace level. | Aug 24, 2023 |
| TraceLevel.Verbose | Enumerations | Specifies Verbose trace level. | Aug 24, 2023 |
| TraceLevel.Warning | Enumerations | Specifies Warning trace level. | Aug 24, 2023 |
| Cube.Transform | Functions | Applies a list of cube functions. | Aug 21, 2023 |
| Value.Is | Functions | Determines whether a value is compatible with the specified type. | Aug 21, 2023 |
| SapHanaRangeOperator.Equals | Enumerations | ‘Equals’ range operator for SAP HANA input parameters. | Aug 18, 2023 |
| SapHanaRangeOperator.GreaterThan | Enumerations | ‘Greater than’ range operator for SAP HANA input parameters. | Aug 18, 2023 |
| SapHanaRangeOperator.GreaterThanOrEquals | Enumerations | ‘Greater than or equals’ range operator for SAP HANA input parameters. | Aug 18, 2023 |
| SapHanaRangeOperator.LessThan | Enumerations | ‘Less than’ range operator for SAP HANA input parameters. | Aug 18, 2023 |
| SapHanaRangeOperator.LessThanOrEquals | Enumerations | ‘Less than or equals’ range operator for SAP HANA input parameters. | Aug 18, 2023 |
| SapHanaRangeOperator.NotEquals | Enumerations | ‘Not equals’ range operator for SAP HANA input parameters. | Aug 18, 2023 |
| Number.BitwiseAnd | Functions | Returns the result of performing a bitwise “And” operation between the two inputs. | Aug 16, 2023 |
| Number.BitwiseNot | Functions | Returns a byte where each bit is the opposite of the input. | Aug 16, 2023 |
| Number.BitwiseOr | Functions | Returns the result of performing a bitwise “Or” between the two inputs. | Aug 16, 2023 |
| Number.BitwiseShiftLeft | Functions | Shifts the bits set to the left. | Aug 16, 2023 |
| Number.BitwiseShiftRight | Functions | Shifts the bits set to the right. | Aug 16, 2023 |
| Number.BitwiseXor | Functions | Returns the result of performing a bitwise “XOR” (Exclusive-OR) between the two inputs. | Aug 16, 2023 |
| Comparer.Equals | Functions | Returns a logical value based on the equality check over the two given values. | Aug 13, 2023 |
| Comparer.Ordinal | Functions | Returns a comparer function which uses Ordinal rules to compare values. | Aug 13, 2023 |
| Comparer.OrdinalIgnoreCase | Functions | Returns a case-insensitive comparer function which uses Ordinal rules to compare values. | Aug 13, 2023 |
| SapHanaDistribution.All | Enumerations | ‘All’ distribution option for SAP HANA. | Aug 10, 2023 |
| SapHanaDistribution.Connection | Enumerations | ‘Connection’ distribution option for SAP HANA. | Aug 10, 2023 |
| SapHanaDistribution.Off | Enumerations | ‘Off’ distribution option for SAP HANA. | Aug 10, 2023 |
| SapHanaDistribution.Statement | Enumerations | ‘Statement’ distribution option for SAP HANA. | Aug 10, 2023 |
| Binary.ToText | Functions | Encodes binary data into a text form. | Aug 5, 2023 |
| Splitter.SplitByNothing | Functions | Returns a function that does no splitting, returning its argument as a single element list. | Aug 5, 2023 |
| Splitter.SplitTextByAnyDelimiter | Functions | Returns a function that splits text into a list of text at any of the specified delimiters. | Aug 5, 2023 |
| Splitter.SplitTextByCharacterTransition | Functions | Returns a function that splits text into a list of text according to a transition from one kind of character to another | Aug 5, 2023 |
| Table.CombineColumnsToRecord | Functions | Combines the specified columns into a new record-valued column where each record has field names and values corresponding to the column names and values of the columns that were combined. | Aug 5, 2023 |
| Duration.ToText | Functions | Returns the text of the form “d.h:m:s”. | Aug 1, 2023 |
| Table.Transpose | Functions | Makes columns into rows and rows into columns. | Aug 1, 2023 |
July 2023
| Name | Category | Description | Last update |
|---|---|---|---|
| List.Accumulate | Functions | Accumulates a summary value from the items in the list. | Jul 21, 2023 |
| List.AllTrue | Functions | Returns true if all expressions are true. | Jul 21, 2023 |
| List.Alternate | Functions | Returns a list comprised of all the odd numbered offset elements in a list. | Jul 21, 2023 |
| Text.NewGuid | Functions | Returns a new, random globally unique identifier (GUID). | Jul 21, 2023 |
| Character.FromNumber | Functions | Converts the number to its character value. | Jul 20, 2023 |
| Character.ToNumber | Functions | Converts a character to its number value. | Jul 20, 2023 |
| Record.FromList | Functions | Returns a record given a list of field values and a set of fields. | Jul 20, 2023 |
| Combiner.CombineTextByDelimiter | Functions | Returns a function that combines a list of text values into a single text value using the specified delimiter. | Jul 15, 2023 |
| Combiner.CombineTextByEachDelimiter | Functions | Returns a function that combines a list of text into a single text using each specified delimiter in sequence. | Jul 15, 2023 |
| BinaryEncoding.Base64 | Enumerations | Constant to use as the encoding type when base-64 encoding is required. | Jul 12, 2023 |
| BinaryEncoding.Hex | Enumerations | Constant to use as the encoding type when hexadecimal encoding is required. | Jul 12, 2023 |
| BinaryOccurrence.Optional | Enumerations | The item is expected to appear zero or one time in the input. | Jul 12, 2023 |
| BinaryOccurrence.Repeating | Enumerations | The item is expected to appear zero or more times in the input. | Jul 12, 2023 |
| BinaryOccurrence.Required | Enumerations | The item is expected to appear once in the input. | Jul 12, 2023 |
| DateTime.FixedLocalNow | Functions | Returns the current date and time in the local timezone | Jul 10, 2023 |
| DateTime.LocalNow | Functions | Returns the current date and time in the local timezone. | Jul 10, 2023 |
| DateTimeZone.FixedLocalNow | Functions | Returns the current date & time in the local timezone | Jul 10, 2023 |
| DateTimeZone.FixedUtcNow | Functions | Returns the current date and time in UTC (the GMT timezone) | Jul 10, 2023 |
| DateTimeZone.From | Functions | Creates a datetimezone from the given value. | Jul 10, 2023 |
| DateTimeZone.FromFileTime | Functions | Creates a datetimezone from a 64 bits long number. | Jul 10, 2023 |
| DateTimeZone.FromText | Functions | Creates a datetimezone from local, universal, and custom datetimezone formats. | Jul 10, 2023 |
| DateTimeZone.LocalNow | Functions | Returns the current date & time in the local timezone. | Jul 10, 2023 |
| DateTimeZone.RemoveZone | Functions | Removes timezone information from the given datetimezone value. | Jul 10, 2023 |
| DateTimeZone.SwitchZone | Functions | Changes the timezone of the value. | Jul 10, 2023 |
| DateTimeZone.ToLocal | Functions | Converts the timezone component to the local timezone. | Jul 10, 2023 |
| DateTimeZone.ToRecord | Functions | Returns a record containing the datetimezone value’s parts. | Jul 10, 2023 |
| DateTimeZone.ToUtc | Functions | Converts the timezone component to UTC timezone. | Jul 10, 2023 |
| DateTimeZone.UtcNow | Functions | Returns the current date and time in UTC (the GMT timezone). | Jul 10, 2023 |
| DateTimeZone.ZoneHours | Functions | Changes the timezone of the value. | Jul 10, 2023 |
| DateTimeZone.ZoneMinutes | Functions | Changes the timezone of the value. | Jul 10, 2023 |
| Expression.Evaluate | Functions | Returns the result of evaluating an M expression. | Jul 6, 2023 |
| Function.InvokeAfter | Functions | Invokes the given function after the specified duration has passed. | Jul 6, 2023 |
| Table.Skip | Functions | Returns a table with the first count rows skipped. | Jul 6, 2023 |
| Number.From | Functions | Creates a number from the given value. | Jul 3, 2023 |
| Text.InferNumberType | Functions | Infers the granular number type (Int64.Type, Double.Type, and so on) of a number encoded in text. | Jul 3, 2023 |
June 2023
| Name | Category | Description | Last update |
|---|---|---|---|
| BufferMode.Delayed | Enumerations | The type of the value is computed immediately but its contents aren’t buffered until data is needed, at which point the entire value is immediately buffered. | Jun 28, 2023 |
| BufferMode.Eager | Enumerations | The entire value is immediately buffered in memory before continuing. | Jun 28, 2023 |
| ByteOrder.BigEndian | Enumerations | A possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The most significant byte appears first in Big Endian byte order. | Jun 28, 2023 |
| ByteOrder.LittleEndian | Enumerations | A possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The least significant byte appears first in Little Endian byte order. | Jun 28, 2023 |
| Compression.Brotli | Enumerations | The compressed data is in the ‘Brotli’ format. | Jun 28, 2023 |
| Compression.Deflate | Enumerations | The compressed data is in the ‘Deflate’ format. | Jun 28, 2023 |
| Compression.GZip | Enumerations | The compressed data is in the ‘GZip’ format. | Jun 28, 2023 |
| Compression.LZ4 | Enumerations | The compressed data is in the ‘LZ4’ format. | Jun 28, 2023 |
| Compression.None | Enumerations | The data is uncompressed. | Jun 28, 2023 |
| Compression.Snappy | Enumerations | The compressed data is in the ‘Snappy’ format. | Jun 28, 2023 |
| Compression.Zstandard | Enumerations | The compressed data is in the ‘Zstandard’ format. | Jun 28, 2023 |
| CsvStyle.QuoteAfterDelimiter | Enumerations | Quotes in a field are only significant immediately following the delimiter. | Jun 28, 2023 |
| CsvStyle.QuoteAlways | Enumerations | Quotes in a field are always significant regardless of where they appear. | Jun 28, 2023 |
| Lines.FromText | Functions | Converts a text value to a list of text values split at lines breaks | Jun 28, 2023 |
| Table.Group | Functions | Groups rows in the table that have the same key. | Jun 28, 2023 |
| Table.Join | Functions | Joins the rows from the two tables that match based on the given keys. | Jun 28, 2023 |
| Table.NestedJoin | Functions | Performs a join between tables on supplied columns and produces the join result in a new column. | Jun 28, 2023 |
| Text.Contains | Functions | Returns whether the text contains the substring. | Jun 28, 2023 |
| Text.EndsWith | Functions | Indicates whether the text ends in the specified value. | Jun 28, 2023 |
| Text.From | Functions | Creates a text value from the given value. | Jun 28, 2023 |
| Text.Length | Functions | Returns the number of characters. | Jun 28, 2023 |
| Text.PositionOf | Functions | Returns the first position of the value (-1 if not found). | Jun 28, 2023 |
| Text.PositionOfAny | Functions | Returns the first position in the text value of any listed character (-1 if not found). | Jun 28, 2023 |
| Text.Replace | Functions | Replaces all occurrences of the given substring in the text. | Jun 28, 2023 |
| Text.ReplaceRange | Functions | Removes a range of characters and inserts a new value at a specified position. | Jun 28, 2023 |
| Text.StartsWith | Functions | Indicates whether the text starts with a specified value. | Jun 28, 2023 |
| Text.Clean | Functions | Returns the text value with all control characters removed. | Jun 27, 2023 |
| Text.Format | Functions | Returns formatted text from a format string and arguments. | Jun 27, 2023 |
| Text.Repeat | Functions | Returns a text value composed of the input text repeated a specified number of times. | Jun 27, 2023 |
| Text.Reverse | Functions | Reverses the provided text | Jun 27, 2023 |
| Text.Split | Functions | Splits text into a list of text values based upon a specified delimiter. | Jun 27, 2023 |
| Text.SplitAny | Functions | Returns a list of text values, split on any of the characters in the delimiter. | Jun 27, 2023 |
| Text.ToList | Functions | Returns a list of character values from the given text value. | Jun 27, 2023 |
| Text.Trim | Functions | Removes all leading and trailing whitespace. | Jun 27, 2023 |
| Table.FromList | Functions | Converts a list into a table by applying the specified splitting function to each item in the list. | Jun 25, 2023 |
| Text.Upper | Functions | Converts all characters to uppercase. | Jun 25, 2023 |
| Day.Friday | Enumerations | Represents Friday. | Jun 24, 2023 |
| Day.Monday | Enumerations | Represents Monday. | Jun 24, 2023 |
| Day.Saturday | Enumerations | Represents Saturday. | Jun 24, 2023 |
| Day.Sunday | Enumerations | Represents Sunday. | Jun 24, 2023 |
| Day.Thursday | Enumerations | Represents Thursday. | Jun 24, 2023 |
| Day.Tuesday | Enumerations | Represents Tuesday. | Jun 24, 2023 |
| Day.Wednesday | Enumerations | Represents Wednesday. | Jun 24, 2023 |
| ExtraValues.Error | Enumerations | If the splitter function returns more columns than the table expects, an error should be raised. | Jun 24, 2023 |
| ExtraValues.Ignore | Enumerations | If the splitter function returns more columns than the table expects, they should be ignored. | Jun 24, 2023 |
| ExtraValues.List | Enumerations | If the splitter function returns more columns than the table expects, they should be collected into a list. | Jun 24, 2023 |
| RankKind.Competition | Enumerations | Identical items receive the same rank. In case of identical items there is a gap before the next rank. This approach may generate non-sequential rankings, with the possibility of repeated rank numbers. | Jun 24, 2023 |
| RankKind.Dense | Enumerations | Identical items receive the same rank and the next ranking item is numbered consecutively without gap. Method guarantees a ranking with consecutive numbers where a rank can appear multiple times. | Jun 24, 2023 |
| RankKind.Ordinal | Enumerations | Every item, even those that are identical, gets a unique rank. Duplicate values get consecutive rankings. | Jun 24, 2023 |
| RelativePosition.FromEnd | Enumerations | Indicates indexing should be done from the end of the input. | Jun 24, 2023 |
| RelativePosition.FromStart | Enumerations | Indicates indexing should be done from the start of the input. | Jun 24, 2023 |
| RoundingMode.AwayFromZero | Enumerations | Round away from zero when there is a tie between the possible numbers to round to. | Jun 24, 2023 |
| RoundingMode.Down | Enumerations | Round down when there is a tie between the possible numbers to round to. | Jun 24, 2023 |
| RoundingMode.ToEven | Enumerations | Round to the nearest even number when there is a tie between the possible numbers to round to. | Jun 24, 2023 |
| RoundingMode.TowardZero | Enumerations | Round toward zero when there is a tie between the possible numbers to round to. | Jun 24, 2023 |
| RoundingMode.Up | Enumerations | Round up when there is a tie between the possible numbers to round to. | Jun 24, 2023 |
| SapBusinessWarehouseExecutionMode.BasXml | Enumerations | ‘bXML flattening mode’ option for MDX execution in SAP Business Warehouse. | Jun 24, 2023 |
| SapBusinessWarehouseExecutionMode.BasXmlGzip | Enumerations | ‘Gzip compressed bXML flattening mode’ option for MDX execution in SAP Business Warehouse. Recommended for low latency or high volume queries. | Jun 24, 2023 |
| SapBusinessWarehouseExecutionMode.DataStream | Enumerations | ‘DataStream flattening mode’ option for MDX execution in SAP Business Warehouse. | Jun 24, 2023 |
| ODataOmitValues.Nulls | Enumerations | Allows the OData service to omit null values. | Jun 22, 2023 |
| Order.Ascending | Enumerations | Sorts the values in ascending order. | Jun 22, 2023 |
| Order.Descending | Enumerations | Sorts the values in descending order. | Jun 22, 2023 |
| PercentileMode.ExcelExc | Enumerations | When interpolating values for List.Percentile, use a method compatible with Excel’s PERCENTILE.EXC. | Jun 22, 2023 |
| PercentileMode.ExcelInc | Enumerations | When interpolating values for List.Percentile, use a method compatible with Excel’s PERCENTILE.INC. | Jun 22, 2023 |
| PercentileMode.SqlCont | Enumerations | When interpolating values for List.Percentile, use a method compatible with SQL Server’s PERCENTILE_CONT. | Jun 22, 2023 |
| PercentileMode.SqlDisc | Enumerations | When interpolating values for List.Percentile, use a method compatible with SQL Server’s PERCENTILE_DISC. | Jun 22, 2023 |
| Precision.Decimal | Enumerations | An optional parameter for the built-in arthimetic operators to specify decimal precision. | Jun 22, 2023 |
| Precision.Double | Enumerations | An optional parameter for the built-in arthimetic operators to specify double precision. | Jun 22, 2023 |
| QuoteStyle.Csv | Enumerations | Quote characters indicate the start of a quoted string. Nested quotes are indicated by two quote characters. | Jun 22, 2023 |
| QuoteStyle.None | Enumerations | Quote characters have no significance. | Jun 22, 2023 |
| Table.Profile | Functions | Returns a profile of the columns of a table. | Jun 22, 2023 |
| Text.Lower | Functions | Converts all characters to lowercase. | Jun 22, 2023 |
| Text.Proper | Functions | Capitalizes the first letter of each word. | Jun 22, 2023 |
| List.Contains | Functions | Indicates whether the list contains the value. | Jun 20, 2023 |
| List.Select | Functions | Returns a list of values that match the condition. | Jun 20, 2023 |
| RowExpression.From | Functions | Returns the abstract syntax tree (AST) for the body of a function. | Jun 20, 2023 |
| Text.At | Functions | Returns the character at the specified position. | Jun 20, 2023 |
| Text.End | Functions | Returns the last characters of the text. | Jun 20, 2023 |
| Text.Insert | Functions | Inserts one text value into another at a given position. | Jun 20, 2023 |
| Text.Middle | Functions | Returns the substring up to a specific length. | Jun 20, 2023 |
| Text.PadEnd | Functions | Returns text of a specified length by padding the end of the given text. | Jun 20, 2023 |
| Text.PadStart | Functions | Returns text of a specified length by padding the start of the given text. | Jun 20, 2023 |
| Text.Range | Functions | Returns the substring found at offset. | Jun 20, 2023 |
| Text.Remove | Functions | Removes all occurrences of the given character or list of characters from the input text value. | Jun 20, 2023 |
| Text.RemoveRange | Functions | Removes a count of characters starting at the given offset | Jun 20, 2023 |
| Text.Select | Functions | Selects all occurrences of the given character or list of characters from the input text value. | Jun 20, 2023 |
| Text.Start | Functions | Returns the start of the text. | Jun 20, 2023 |
| Text.TrimEnd | Functions | Removes all trailing whitespace. | Jun 20, 2023 |
| Text.TrimStart | Functions | Removes all leading whitespace. | Jun 20, 2023 |
| #binary | Functions | Creates a binary value from a list of numbers or a base 64 encoded text value. | Jun 15, 2023 |
| #date | Functions | Creates a date value from whole numbers representing the year, month, and day. | Jun 15, 2023 |
| #datetime | Functions | Creates a datetime value from numbers representing the year, month, day, hour, minute, and (fractional) second. | Jun 15, 2023 |
| #datetimezone | Functions | Creates a datetimezone value from numbers representing the year, month, day, hour, minute, (fractional) second, (fractional) offset-hours, and offset-minutes. | Jun 15, 2023 |
| #duration | Functions | Creates a duration value from numbers representing days, hours, minutes, and (fractional) seconds. | Jun 15, 2023 |
| #table | Functions | Creates a table value from columns and rows. | Jun 15, 2023 |
| #time | Functions | Creates a time value from numbers representing the hour, minute, and (fractional) second. | Jun 15, 2023 |
| Number.Round | Functions | Returns the rounded number | Jun 11, 2023 |
| SapHana.Database | Functions | Returns the packages in an SAP HANA database. | Jun 11, 2023 |
| Text.AfterDelimiter | Functions | Returns the portion of text after the specified delimiter | Jun 11, 2023 |
| Text.BeforeDelimiter | Functions | Returns the portion of text before the specified delimiter | Jun 11, 2023 |
| Text.BetweenDelimiters | Functions | Returns the portion of text between the specified startDelimiter and endDelimiter | Jun 11, 2023 |
| GroupKind.Global | Enumerations | A global group is formed from all rows in an input table with the same key value. | Jun 10, 2023 |
| GroupKind.Local | Enumerations | A local group is formed from a consecutive sequence of rows from an input table with the same key value. That means two rows with the same value will be placed in different groups if there’s a row with a different value between them. | Jun 10, 2023 |
| JoinAlgorithm.Dynamic | Enumerations | Automatically chooses a join algorithm based on inspecting the initial rows and metadata of both tables. | Jun 10, 2023 |
| JoinAlgorithm.LeftHash | Enumerations | Buffers the left rows into a lookup table and streams the right rows. For each right row, the matching left rows are found via the buffered lookup table. This algorithm is recommended when the left table is small and most of the rows from the right table are expected to match a left row. | Jun 10, 2023 |
| JoinAlgorithm.LeftIndex | Enumerations | In batches, uses the keys from the left table to do predicate-based queries against the right table. This algorithm is recommended when the right table is large, supports folding of Table.SelectRows, and contains few rows that are expected to match a left row. | Jun 10, 2023 |
| JoinAlgorithm.PairwiseHash | Enumerations | Buffers the rows of both the left and right tables until one of the tables is completely buffered, and then performs a LeftHash or RightHash, depending on which table was buffered completely. This algorithm is recommended only for small tables. | Jun 10, 2023 |
| JoinAlgorithm.RightHash | Enumerations | Buffers the right rows into a lookup table and streams the left rows. For each left row, the matching right rows are found via the buffered lookup table. This algorithm is recommended when the right table is small and most of the rows from the left table are expected to match a right row. | Jun 10, 2023 |
| JoinAlgorithm.RightIndex | Enumerations | In batches, uses the keys from the right table to do predicate-based queries against the left table. This algorithm is recommended when the left table is large, supports folding of Table.SelectRows, and contains few rows that are expected to match a right row. | Jun 10, 2023 |
| JoinAlgorithm.SortMerge | Enumerations | Performs a streaming merge based on the assumption that both tables are sorted by their join keys. While efficient, it will return incorrect results if the tables aren’t sorted as expected. | Jun 10, 2023 |
| JoinKind.FullOuter | Enumerations | A possible value for the optional JoinKind parameter in Table.Join. A full outer join ensures that all rows of both tables appear in the result. Rows that did not have a match in the other table are joined with a default row containing null values for all of its columns. | Jun 10, 2023 |
| JoinKind.Inner | Enumerations | A possible value for the optional JoinKind parameter in Table.Join. The table resulting from an inner join contains a row for each pair of rows from the specified tables that were determined to match based on the specified key columns. | Jun 10, 2023 |
| JoinKind.LeftAnti | Enumerations | A possible value for the optional JoinKind parameter in Table.Join. A left anti join returns that all rows from the first table which do not have a match in the second table. | Jun 10, 2023 |
| JoinKind.LeftOuter | Enumerations | A possible value for the optional JoinKind parameter in Table.Join. A left outer join ensures that all rows of the first table appear in the result. | Jun 10, 2023 |
| JoinKind.RightAnti | Enumerations | A possible value for the optional JoinKind parameter in Table.Join. A right anti join returns that all rows from the second table which do not have a match in the first table. | Jun 10, 2023 |
| JoinKind.RightOuter | Enumerations | A possible value for the optional JoinKind parameter in Table.Join. A right outer join ensures that all rows of the second table appear in the result. | Jun 10, 2023 |
May 2023
| Name | Category | Description | Last update |
|---|---|---|---|
| MissingField.Error | Enumerations | An optional parameter in record and table functions indicating that missing fields should result in an error. (This is the default parameter value.) | May 30, 2023 |
| MissingField.Ignore | Enumerations | An optional parameter in record and table functions indicating that missing fields should be ignored. | May 30, 2023 |
| MissingField.UseNull | Enumerations | An optional parameter in record and table functions indicating that missing fields should be included as null values. | May 30, 2023 |
| Occurrence.All | Enumerations | A list of positions of all occurrences of the found values is returned. | May 30, 2023 |
| Occurrence.First | Enumerations | The position of the first occurrence of the found value is returned. | May 30, 2023 |
| Occurrence.Last | Enumerations | The position of the last occurrence of the found value is returned. | May 30, 2023 |
| Binary.Compress | Functions | Compresses a binary value using the given compression type. | May 25, 2023 |
| BinaryFormat.Group | Functions | Returns a binary format that reads a group of items. | May 25, 2023 |
| Table.Pivot | Functions | Given a pair of columns representing attribute-value pairs, rotates the data in the attribute column into a column headings. | May 25, 2023 |
| List.Generate | Functions | Generates a list of values. | May 20, 2023 |
| List.Sort | Functions | Sorts a list of data according to the criteria specified. | May 20, 2023 |
| Table.Distinct | Functions | Removes duplicate rows from the table. | May 20, 2023 |
| Text.Combine | Functions | Concatenates a list of text values into one text value. | May 20, 2023 |
