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.
October 2024
| Name | Category | Description | Last update |
|---|---|---|---|
| Table.RemoveFirstN | Functions | Returns a table with the first count rows skipped. | Oct 1, 2024 |
| Value.ResourceExpression | Functions | Generates a record representing a given value’s resource expression. | Oct 1, 2024 |
September 2024
| Name | Category | Description | Last update |
|---|---|---|---|
| JoinKind.LeftSemi | Enumerations | A left semi join returns all rows from the first table that have a match in the second table. | Sep 8, 2024 |
| JoinKind.RightSemi | Enumerations | A right semi join returns all rows from the second table that have a match in the first table. | Sep 8, 2024 |
| Table.Partition | Functions | Partitions the table into a list of tables based on the number of groups and column specified. | Sep 2, 2024 |
| Table.PartitionValues | Functions | Returns information about how a table is partitioned. | Sep 2, 2024 |
| Table.RowCount | Functions | Returns the number of rows in the table. | Sep 2, 2024 |
| Table.Split | Functions | Splits the specified table into a list of tables using the specified page size. | Sep 2, 2024 |
| Table.SplitAt | Functions | Returns a list containing the first count rows specified and the remaining rows. | Sep 2, 2024 |
| Table.ToColumns | Functions | Creates a list of nested lists of column values from a table. | Sep 1, 2024 |
| Table.ToList | Functions | Converts a table into a list by applying the specified combining function to each row of values in the table. | Sep 1, 2024 |
| Table.ToRecords | Functions | Converts a table to a list of records. | Sep 1, 2024 |
| Table.ToRows | Functions | Creates a list of nested lists of row values from a table. | Sep 1, 2024 |
August 2024
| Name | Category | Description | Last update |
|---|---|---|---|
| Table.FromColumns | Functions | Creates a table from a list of columns and specified values. | Aug 30, 2024 |
| Table.FromList | Functions | Converts a list into a table by applying the specified splitting function to each item in the list. | Aug 30, 2024 |
| Table.FromPartitions | Functions | Returns a table that is the result of combining a set of partitioned tables. | Aug 30, 2024 |
| Table.FromRecords | Functions | Converts a list of records into a table. | Aug 30, 2024 |
| Table.FromRows | Functions | Creates a table from a list of row values and optional columns | Aug 30, 2024 |
| Table.FromValue | Functions | Creates a table with a column from the provided value(s). | Aug 30, 2024 |
| Table.Unpivot | Functions | Translates a set of columns in a table into attribute-value pairs. | Aug 29, 2024 |
| Table.UnpivotOtherColumns | Functions | Translates all columns other than a specified set into attribute-value pairs. | Aug 29, 2024 |
July 2024
| Name | Category | Description | Last update |
|---|---|---|---|
| DateTime.IsInCurrentHour | Functions | Indicates whether this datetime occurs during the current hour. | Jul 8, 2024 |
| DateTime.IsInCurrentMinute | Functions | Indicates whether this datetime occurs during the current minute. | Jul 8, 2024 |
| DateTime.IsInCurrentSecond | Functions | Indicates whether this datetime occurs during the current second. | Jul 8, 2024 |
| DateTime.IsInNextHour | Functions | Indicates whether this datetime occurs during the next hour | Jul 8, 2024 |
| DateTime.IsInNextMinute | Functions | Indicates whether this datetime occurs during the next minute | Jul 8, 2024 |
| DateTime.IsInNextNHours | Functions | Indicates whether this datetime occurs during the next number of hours | Jul 8, 2024 |
| DateTime.IsInNextNMinutes | Functions | Indicates whether this datetime occurs during the next number of minutes | Jul 8, 2024 |
| DateTime.IsInNextNSeconds | Functions | Indicates whether this datetime occurs during the next number of seconds | Jul 8, 2024 |
| DateTime.IsInNextSecond | Functions | Indicates whether this datetime occurs during the next second | Jul 8, 2024 |
| DateTime.IsInPreviousHour | Functions | Indicates whether this datetime occurs during the previous hour | Jul 8, 2024 |
| DateTime.IsInPreviousMinute | Functions | Indicates whether this datetime occurs during the previous minute | Jul 8, 2024 |
| DateTime.IsInPreviousNHours | Functions | Indicates whether this datetime occurs during the previous number of hours | Jul 8, 2024 |
| DateTime.IsInPreviousNMinutes | Functions | Indicates whether this datetime occurs during the previous number of minutes | Jul 8, 2024 |
| DateTime.IsInPreviousNSeconds | Functions | Indicates whether this datetime occurs during the previous number of seconds | Jul 8, 2024 |
| DateTime.IsInPreviousSecond | Functions | Indicates whether this datetime occurs during the previous second | Jul 8, 2024 |
| RankKind.Ordinal | Enumerations | Every item, even those that are identical, gets a unique rank. Duplicate values get consecutive rankings. | Jul 8, 2024 |
| Date.IsInCurrentDay | Functions | Indicates whether this date occurs during the current day. | Jul 7, 2024 |
| Date.IsInCurrentMonth | Functions | Indicates whether this date occurs during the current month. | Jul 7, 2024 |
| Date.IsInCurrentQuarter | Functions | Indicates whether this date occurs during the current quarter. | Jul 7, 2024 |
| Date.IsInCurrentWeek | Functions | Indicates whether this date occurs during the current week. | Jul 7, 2024 |
| Date.IsInCurrentYear | Functions | Indicates whether this date occurs during the current year. | Jul 7, 2024 |
| Date.IsInNextDay | Functions | Indicates whether this date occurs during the next day | Jul 7, 2024 |
| Date.IsInNextMonth | Functions | Indicates whether this date occurs during the next month | Jul 7, 2024 |
| Date.IsInNextNDays | Functions | Indicates whether this date occurs during the next number of days | Jul 7, 2024 |
| Date.IsInNextNMonths | Functions | Indicates whether this date occurs during the next number of months | Jul 7, 2024 |
| Date.IsInNextNQuarters | Functions | Indicates whether this date occurs during the next number of quarters | Jul 7, 2024 |
| Date.IsInNextNWeeks | Functions | Indicates whether this date occurs during the next number of weeks | Jul 7, 2024 |
| Date.IsInNextNYears | Functions | Indicates whether this date occurs during the next number of years | Jul 7, 2024 |
| Date.IsInNextQuarter | Functions | Indicates whether this date occurs during the next quarter | Jul 7, 2024 |
| Date.IsInNextWeek | Functions | Indicates whether this date occurs during the next week | Jul 7, 2024 |
| Date.IsInNextYear | Functions | Indicates whether this date occurs during the next year | Jul 7, 2024 |
| Date.IsInPreviousDay | Functions | Indicates whether this date occurs during the previous day | Jul 7, 2024 |
| Date.IsInPreviousMonth | Functions | Indicates whether this date occurs during the previous month | Jul 7, 2024 |
| Date.IsInPreviousNDays | Functions | Indicates whether this date occurs during the previous number of days | Jul 7, 2024 |
| Date.IsInPreviousNMonths | Functions | Indicates whether this date occurs during the previous number of months | Jul 7, 2024 |
| Date.IsInPreviousNQuarters | Functions | Indicates whether this date occurs during the previous number of quarters | Jul 7, 2024 |
| Date.IsInPreviousNWeeks | Functions | Indicates whether this date occurs during the previous number of weeks | Jul 7, 2024 |
| Date.IsInPreviousNYears | Functions | Indicates whether this date occurs during the previous number of years | Jul 7, 2024 |
| Date.IsInPreviousQuarter | Functions | Indicates whether this date occurs during the previous quarter | Jul 7, 2024 |
| Date.IsInPreviousWeek | Functions | Indicates whether this date occurs during the previous week | Jul 7, 2024 |
| Date.IsInPreviousYear | Functions | Indicates whether this date occurs during the previous year | Jul 7, 2024 |
| Date.IsInYearToDate | Functions | Indicates whether this date occurs during the current year and is on or before the current day. | Jul 7, 2024 |
| Date.IsLeapYear | Functions | Indicates whether this date falls in a leap year. | Jul 7, 2024 |
| #binary | Functions | Creates a binary value from a list of numbers or a base 64 encoded text value. | Jul 2, 2024 |
| #date | Functions | Creates a date value from whole numbers representing the year, month, and day. | Jul 2, 2024 |
| #datetimezone | Functions | Creates a datetimezone value from numbers representing the year, month, day, hour, minute, (fractional) second, (fractional) offset-hours, and offset-minutes. | Jul 2, 2024 |
| #duration | Functions | Creates a duration value from numbers representing days, hours, minutes, and (fractional) seconds. | Jul 2, 2024 |
| #table | Functions | Creates a table value from columns and rows. | Jul 2, 2024 |
| #time | Functions | Creates a time value from numbers representing the hour, minute, and (fractional) second. | Jul 2, 2024 |
| Expression.Constant | Functions | Returns the M source code representation of a constant value. | Jul 2, 2024 |
| Expression.Evaluate | Functions | Returns the result of evaluating an M expression. | Jul 2, 2024 |
| Expression.Identifier | Functions | Returns the M source code representation of an identifier. | Jul 2, 2024 |
| Logical.From | Functions | Creates a logical from the given value. | Jul 2, 2024 |
| Logical.FromText | Functions | Creates a logical value from the text values “true” and “false”. | Jul 2, 2024 |
| Logical.ToText | Functions | Returns the text “true” or “false” given a logical value. | Jul 2, 2024 |
| Time.EndOfHour | Functions | Returns the end of the hour. | Jul 1, 2024 |
| Time.From | Functions | Creates a time from the given value. | Jul 1, 2024 |
| Time.FromText | Functions | Creates a Time from local and universal, and custom Time formats. | Jul 1, 2024 |
| Time.StartOfHour | Functions | Returns the start of the hour. | Jul 1, 2024 |
| Time.ToRecord | Functions | Returns a record containing the Time value’s parts. | Jul 1, 2024 |
| Time.ToText | Functions | Returns a textual representation of the time value. | Jul 1, 2024 |
June 2024
| Name | Category | Description | Last update |
|---|---|---|---|
| Text.PositionOfAny | Functions | Returns the first position in the text value of any listed character (-1 if not found). | Jun 18, 2024 |
| Time.Hour | Functions | Returns the hour component. | Jun 15, 2024 |
| Time.Minute | Functions | Returns the minute component. | Jun 15, 2024 |
| Time.Second | Functions | Returns the second component. | Jun 15, 2024 |
| DateTime.AddZone | Functions | Adds timezone information to the datetime value. | Jun 13, 2024 |
| DateTime.Date | Functions | Returns the date component of the given date, datetime, or datetimezone value. | Jun 13, 2024 |
| DateTime.FixedLocalNow | Functions | Returns the current date and time in the local timezone | Jun 13, 2024 |
| Date.EndOfWeek | Functions | Returns the end of the week. | Jun 12, 2024 |
| Date.EndOfYear | Functions | Returns the end of the year. | Jun 12, 2024 |
| Date.StartOfDay | Functions | Returns the start of the day. | Jun 12, 2024 |
| Date.StartOfMonth | Functions | Returns the start of the month. | Jun 12, 2024 |
| Date.StartOfQuarter | Functions | Returns the start of the quarter. | Jun 12, 2024 |
| Date.StartOfWeek | Functions | Returns the start of the week. | Jun 12, 2024 |
| Date.StartOfYear | Functions | Returns the start of the year. | Jun 12, 2024 |
| Date.ToRecord | Functions | Returns a record containing parts of the date value. | Jun 12, 2024 |
| Date.WeekOfMonth | Functions | Returns a number from 1 to 6 indicating which week of the month this date falls in. | Jun 12, 2024 |
| Date.Year | Functions | Returns the year component. | Jun 12, 2024 |
| DateTime.From | Functions | Creates a datetime from the given value. | Jun 12, 2024 |
| DateTime.FromFileTime | Functions | Creates a datetime from a 64 bits long number. | Jun 12, 2024 |
| DateTime.FromText | Functions | Creates a datetimezone from local and universal datetime formats. | Jun 12, 2024 |
| DateTime.Time | Functions | Returns the time part of the given datetime value. | Jun 12, 2024 |
| DateTime.ToRecord | Functions | Returns a record containing the datetime value’s parts. | Jun 12, 2024 |
| Date.From | Functions | Creates a date from the given value. | Jun 11, 2024 |
| Date.FromText | Functions | Creates a Date from local, universal, and custom Date formats. | Jun 11, 2024 |
| Date.Month | Functions | Returns the month component. | Jun 11, 2024 |
| Date.MonthName | Functions | Returns the name of the month component. | Jun 11, 2024 |
| Date.QuarterOfYear | Functions | Returns a number indicating which quarter of the year the date falls in. | Jun 11, 2024 |
| Duration.From | Functions | Creates a duration from the given value. | Jun 11, 2024 |
| Duration.FromText | Functions | Returns a duration value from textual elapsed time forms (d.h:m:s). | Jun 11, 2024 |
| Duration.ToRecord | Functions | Returns a record containing the parts of the duration. | Jun 11, 2024 |
| Guid.From | Functions | Returns a guid value from the given value. | Jun 11, 2024 |
| Record.AddField | Functions | Adds a field to a record. | Jun 11, 2024 |
| Record.Combine | Functions | Combines the records in the given list. | Jun 11, 2024 |
| Record.Field | Functions | Returns the value of the specified field in a record. | Jun 11, 2024 |
| Record.FieldCount | Functions | Returns the number of fields in the record. | Jun 11, 2024 |
| Record.FieldNames | Functions | Returns the names of the fields. | Jun 11, 2024 |
| Record.FieldOrDefault | Functions | Returns the value of the specified field in a record or the default value if the field is not found. | Jun 11, 2024 |
| Record.FieldValues | Functions | Returns a list of the field values. | Jun 11, 2024 |
| Record.FromList | Functions | Returns a record given a list of field values and a set of fields. | Jun 11, 2024 |
| Record.FromTable | Functions | Creates a record from a table of the form {[Name = name, Value = value]}. | Jun 11, 2024 |
| Record.HasFields | Functions | Indicates whether the record has the specified fields. | Jun 11, 2024 |
| Record.RemoveFields | Functions | Removes the specified field(s) from the input record. | Jun 11, 2024 |
| Record.RenameFields | Functions | Applies rename(s) from a list in the form { old, new }. | Jun 11, 2024 |
| Record.ReorderFields | Functions | Reorders the field(s) specified into the new order. | Jun 11, 2024 |
| Record.SelectFields | Functions | Returns a record that contains only the specified fields. | Jun 11, 2024 |
| Record.ToList | Functions | Returns a list of values containing the field values of the input record. | Jun 11, 2024 |
| Record.ToTable | Functions | Returns a table with each row being a field name and value of the input record. | Jun 11, 2024 |
| Record.TransformFields | Functions | Returns a record after applying specified transformations. | Jun 11, 2024 |
| Text.Combine | Functions | Concatenates a list of text values into one text value. | Jun 11, 2024 |
| Date.Day | Functions | Returns the day component. | Jun 10, 2024 |
| Date.DayOfWeek | Functions | Returns a number (from 0 to 6) indicating the day of the week of the provided value. | Jun 10, 2024 |
| Date.DayOfWeekName | Functions | Returns the day of the week name. | Jun 10, 2024 |
| Date.DayOfYear | Functions | Returns a number from 1 to 366 representing the day of the year. | Jun 10, 2024 |
| Date.DaysInMonth | Functions | Returns a number from 28 to 31 indicating the number of days in the month. | Jun 10, 2024 |
| Date.AddDays | Functions | Adds the specified days to the date. | Jun 9, 2024 |
| Date.AddMonths | Functions | Adds the specified months to the date. | Jun 9, 2024 |
| Date.AddQuarters | Functions | Adds the specified quarters to the date. | Jun 9, 2024 |
| Date.AddWeeks | Functions | Adds the specified weeks to the date. | Jun 9, 2024 |
| Date.AddYears | Functions | Adds the specified years to the date. | Jun 9, 2024 |
| Date.EndOfDay | Functions | Returns the end of the day. | Jun 9, 2024 |
| Date.EndOfMonth | Functions | Returns the end of the month. | Jun 9, 2024 |
| Date.EndOfQuarter | Functions | Returns the end of the quarter. | Jun 9, 2024 |
| Binary.FromText | Functions | Decodes data from a text form into binary. | Jun 8, 2024 |
| Duration.Days | Functions | Returns the days portion of a duration. | Jun 8, 2024 |
| Duration.Hours | Functions | Returns the hours portion of a duration. | Jun 8, 2024 |
| Duration.Minutes | Functions | Returns the minutes portion of a duration. | Jun 8, 2024 |
| Duration.Seconds | Functions | Returns the seconds portion of a duration. | Jun 8, 2024 |
| Duration.TotalDays | Functions | Returns the total days this duration spans. | Jun 8, 2024 |
| Duration.TotalHours | Functions | Returns the total hours this duration spans. | Jun 8, 2024 |
| Duration.TotalMinutes | Functions | Returns the total minutes this duration spans. | Jun 8, 2024 |
| Duration.TotalSeconds | Functions | Returns the total seconds this duration spans. | Jun 8, 2024 |
| List.ContainsAny | Functions | Indicates where a list includes any of the values in another list. | Jun 8, 2024 |
| List.Mode | Functions | Returns the most frequent value in the list. | Jun 8, 2024 |
| List.Modes | Functions | Returns a list of the most frequent values in the list. | Jun 8, 2024 |
May 2024
| Name | Category | Description | Last update |
|---|---|---|---|
| List.RemoveItems | Functions | Removes items from list1 that are present in list. | May 4, 2024 |
| Table.Group | Functions | Groups rows in the table that have the same key. | May 4, 2024 |
April 2024
| Name | Category | Description | Last update |
|---|---|---|---|
| Module.Versions | Functions | Returns a record of module versions for the current module and its dependencies. | Apr 30, 2024 |
| SparkProtocol.Azure | Enumerations | Specifies the Azure protocol to connect to an instance of Spark. | Apr 28, 2024 |
| SparkProtocol.HTTP | Enumerations | Specifies the Standard protocol to connect to an instance of Spark. | Apr 28, 2024 |
| SparkProtocol.Standard | Enumerations | Specifies the Standard protocol to connect to an instance of Spark. | Apr 28, 2024 |
| List.Median | Functions | Returns the median value in the list. | Apr 25, 2024 |
| List.Average | Functions | Returns the average of the values | Apr 24, 2024 |
| List.Contains | Functions | Indicates whether the list contains the value. | Apr 24, 2024 |
| List.ContainsAll | Functions | Indicates where a list includes all the values in another list. | Apr 24, 2024 |
| List.Dates | Functions | Generates a list of date values given an initial value, count, and incremental duration value. | Apr 24, 2024 |
| List.IsDistinct | Functions | Indicates whether there are duplicates in the list. | Apr 24, 2024 |
| List.Product | Functions | Returns the product of the numbers in the list. | Apr 24, 2024 |
| List.Sum | Functions | Returns the sum of the items in the list. | Apr 24, 2024 |
| Table.CombineColumns | Functions | Combines the specified columns into a new column using the specified combiner function. | Apr 2, 2024 |
March 2024
| Name | Category | Description | Last update |
|---|---|---|---|
| DateTimeZone.FixedLocalNow | Functions | Returns the current date & time in the local timezone | Mar 8, 2024 |
| DateTimeZone.FixedUtcNow | Functions | Returns the current date and time in UTC (the GMT timezone) | Mar 8, 2024 |
January 2024
| Name | Category | Description | Last update |
|---|---|---|---|
| Table.SelectRows | Functions | Selects the rows that meet the condition function. | Jan 4, 2024 |
| Table.AddColumn | Functions | Adds a column with the specified name | Jan 3, 2024 |
| Table.Combine | Functions | Returns a table that is the result of merging a list of tables. | Jan 3, 2024 |
| GeographyPoint.From | Functions | Creates a record representing a geographic point from parts. | Jan 1, 2024 |
| Geometry.FromWellKnownText | Functions | Translates text representing a geometric value in Well-Known Text (WKT) format into a structured record. | Jan 1, 2024 |
| Geometry.ToWellKnownText | Functions | Translates a structured geometric point value into its Well-Known Text (WKT) representation. | Jan 1, 2024 |
| GeometryPoint.From | Functions | Creates a record representing a geometric point from parts. | Jan 1, 2024 |
December 2023
| Name | Category | Description | Last update |
|---|---|---|---|
| Geography.FromWellKnownText | Functions | Translates text representing a geographic value in Well-Known Text (WKT) format into a structured record. | Dec 31, 2023 |
| Geography.ToWellKnownText | Functions | Translates a structured geographic point value into its Well-Known Text (WKT) representation. | Dec 31, 2023 |
| Table.ColumnsOfType | Functions | Returns a list with the names of the columns that match the specified types. | Dec 26, 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. | Dec 20, 2023 |
| Date.WeekOfYear | Functions | Returns a number from 1 to 54 indicating which week of the year this date falls in. | Dec 18, 2023 |
| List.Count | Functions | Returns the number of items in the list. | Dec 15, 2023 |
| List.NonNullCount | Functions | Returns the number of non-null items in the list. | Dec 15, 2023 |
| Table.TransformColumnTypes | Functions | Applies type transformation(s) of the form { column, type } using a specific culture. | Dec 11, 2023 |
| Value.Versions | Functions | Returns a navigation table containing the available versions of value. | Dec 10, 2023 |
| Table.Sort | Functions | Sorts the table using one or more column names and comparison criteria. | Dec 8, 2023 |
| Facets | Pages | Type facets provide additional type information that can be used by external systems for improved data storage and handling. | Dec 6, 2023 |
| List.Distinct | Functions | Returns a list of values with duplicates removed. | Dec 3, 2023 |
| Binary.Decompress | Functions | Decompresses a binary value using the given compression type. | Dec 2, 2023 |
| BinaryFormat.ByteOrder | Functions | Returns a binary format with the byte order specified by a function. | Dec 2, 2023 |
| Cube.Transform | Functions | Applies a list of cube functions. | Dec 2, 2023 |
| List.Percentile | Functions | Returns one or more sample percentiles corresponding to the given probabilities. | Dec 2, 2023 |
| OData.Feed | Functions | Returns a table of OData feeds offered by an OData service. | Dec 2, 2023 |
| Odbc.DataSource | Functions | Returns a table of SQL tables and views from the ODBC data source | Dec 2, 2023 |
| SapBusinessWarehouse.Cubes | Functions | Returns the InfoCubes and queries in an SAP Business Warehouse system grouped by InfoArea. | Dec 2, 2023 |
| Table.FuzzyJoin | Functions | Joins the rows from the two tables that fuzzy match based on the given keys. | Dec 2, 2023 |
| Table.FuzzyNestedJoin | Functions | Performs a fuzzy join between tables on supplied columns and produces the join result in a new column. | Dec 2, 2023 |
| Table.Join | Functions | Joins the rows from the two tables that match based on the given keys. | Dec 2, 2023 |
| TextEncoding.Ascii | Enumerations | Use to choose the ASCII binary form. | Dec 2, 2023 |
| TextEncoding.BigEndianUnicode | Enumerations | Use to choose the UTF16 big endian binary form. | Dec 2, 2023 |
| TextEncoding.Unicode | Enumerations | Use to choose the UTF16 little endian binary form. | Dec 2, 2023 |
| TextEncoding.Utf16 | Enumerations | Use to choose the UTF16 little endian binary form. | Dec 2, 2023 |
| TextEncoding.Utf8 | Enumerations | Use to choose the UTF8 binary form. | Dec 2, 2023 |
| TextEncoding.Windows | Enumerations | Use to choose the Windows binary form. | Dec 2, 2023 |
| WebAction.Request | Functions | Creates an action that, when executed, will return the results of performing an HTTP request as a binary value. | Dec 2, 2023 |
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 | |
| Diagnostics.CorrelationId | New | Returns an opaque identifier to correlate incoming requests with outgoing ones. | 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 |
| Data Types | Pages | This article delves into data types. It shows the available types, their characteristics, and how to use them. | Nov 22, 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 |
| 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 |
| 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 |
| Error Messages | Pages | This article addresses the most common error messages in Power Query. | Oct 16, 2023 |
| Operators | Pages | This article describes the operators used in the Power Query M language. | Oct 1, 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 |
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.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.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 |
| 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 |
| 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 |
| 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.LocalNow | Functions | Returns the current date and time in the local 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 |
| 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.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.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 |
| 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 |
| 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.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 |
| #datetime | Functions | Creates a datetime value from numbers representing the year, month, day, 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 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 | 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 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 left outer join ensures that all rows of the first table appear in the result. | Jun 10, 2023 |
| JoinKind.RightAnti | Enumerations | 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 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 |
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy