Updated Articles


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, and Pages.

Use this page to stay up-to-date with the Power Query M language functions and to keep track of updated articles.

December 2024

NameCategoryDescriptionLast update
Action.SequenceFunctionsCreates an action that executes a sequence of actions in order.30 Dec 24
Byte.FromFunctionsCreates an 8-bit integer from the given value.30 Dec 24
Crypto.CreateHashFunctions30 Dec 24
Extension.ContentsFunctions30 Dec 24
Extension.CurrentCredentialFunctions30 Dec 24
Extension.LoadStringFunctions30 Dec 24
List.ReplaceValueFunctionsSearches a list for the specified value and replaces it.30 Dec 24
OpenApi.DocumentFunctionsReturns a table of operations from an Open API definition.30 Dec 24
TableAction.DeleteRowsFunctionsCreates an action to delete rows from a table.30 Dec 24
TableAction.InsertRowsFunctionsCreates an action to insert rows into a table.30 Dec 24
TableAction.UpdateRowsFunctionsCreates an action to update rows in a table.30 Dec 24
Web.DefaultProxyFunctions30 Dec 24
Action.DoNothingNewAn action that performs no action when executed and returns null as its result.23 Dec 24
Action.ReturnNewCreates an action that performs no action when executed and returns the specified value as its result.23 Dec 24
Action.SequenceNewCreates an action that executes a sequence of actions in order.23 Dec 24
Action.TryNewCreates an action that executes the specified action, catching and returning any errors that occur during its execution.23 Dec 24
Action.ViewNewCreates or extends an action with user-defined handlers for query and action operations.23 Dec 24
Action.ViewErrorNewCreates a modified error record which won’t trigger a fallback when thrown by a handler defined on a view (via Action.View).23 Dec 24
Action.ViewFunctionNewCreates a function that can be intercepted by a handler defined on a view (via Binary.View).23 Dec 24
Crypto.CreateHashNew23 Dec 24
Crypto.CreateHmacNew23 Dec 24
DataSource.TestConnectionNewReturns whether a connection to a datasource can be established and credentials are correct.23 Dec 24
Environment.ConfigurationNewReturns the value of all configuration properties set in the current environment.23 Dec 24
Environment.FeatureSwitchNewReturns the value of a configuration property set in the current environment.23 Dec 24
Environment.LibrariesNewReturns a table of libraries that are available in the current environment.23 Dec 24
Error.UnexpectedNew23 Dec 24
Extension.CacheNew23 Dec 24
Extension.ContentsNew23 Dec 24
Extension.CredentialErrorNew23 Dec 24
Extension.CurrentApplicationNew23 Dec 24
Extension.CurrentCredentialNew23 Dec 24
Extension.HasPermissionNew23 Dec 24
Extension.InvokeVolatileFunctionNew23 Dec 24
Extension.InvokeWithCredentialsNew23 Dec 24
Extension.InvokeWithPermissionsNew23 Dec 24
Extension.LoadStringNew23 Dec 24
Extension.ModuleNew23 Dec 24
Extension.StateNew23 Dec 24
List.ParallelInvokeNewEvaluates the provided list of functions with up to concurrency functions evaluated concurrently23 Dec 24
OpenApi.DocumentNewReturns a table of operations from an Open API definition.23 Dec 24
SqlView.GeneratorNewThis function is intended for internal use only.23 Dec 24
TableAction.DeleteRowsNewCreates an action to delete rows from a table.23 Dec 24
TableAction.InsertRowsNewCreates an action to insert rows into a table.23 Dec 24
TableAction.TeeNewCreates an action that executes multiple actions concurrently while reading data from a table.23 Dec 24
TableAction.UpdateRowsNewCreates an action to update rows in a table.23 Dec 24
ValueAction.BeginTransactionNew23 Dec 24
ValueAction.CommitTransactionNew23 Dec 24
ValueAction.NativeStatementNewCreates an action to execute a statement against a target.23 Dec 24
ValueAction.ReplaceNewCreates an action that replaces the content of a value with the specified value.23 Dec 24
Web.DefaultProxyNew23 Dec 24
Web.SignForOAuth1New23 Dec 24
Uri.BuildQueryStringFunctionsAssemble a record into a URI query string.22 Dec 24
Uri.CombineFunctionsReturns an absolute URI that is the combination of the input base URI and relative URI.22 Dec 24
Uri.EscapeDataStringFunctionsEncodes special characters in accordance with RFC 3986.22 Dec 24
Uri.PartsFunctionsReturns the parts of the input absolute URI as a record.22 Dec 24
Table.SchemaFunctionsReturns a table containing a description of the columns (i.e18 Dec 24
Type.TableSchemaFunctionsReturns a table containing a description of the columns (i.e18 Dec 24

November 2024

NameCategoryDescriptionLast update
Type.IsFunctionsDetermines if a value of the first type is always compatible with the second type.21 Nov 24
Value.AddFunctionsReturns the sum of the two values.19 Nov 24
Value.CompareFunctionsReturns -1, 0, or 1 based on whether the first value is less than, equal to, or greater than the second.19 Nov 24
Value.DivideFunctionsReturns the result of dividing the first value by the second.19 Nov 24
Value.EqualsFunctionsReturns whether two values are equal.19 Nov 24
Value.MultiplyFunctionsReturns the product of the two values.19 Nov 24
Value.SubtractFunctionsReturns the difference of the two values.19 Nov 24
Value.MetadataFunctionsReturns a record containing the input’s metadata.18 Nov 24
Value.RemoveMetadataFunctionsStrips the input of metadata.18 Nov 24
Value.ReplaceMetadataFunctionsReplaces the input’s metadata information.18 Nov 24
Table.AddIndexColumnFunctionsAppends a column with explicit position values.15 Nov 24
Table.AddRankColumnFunctionsAppends a column with the ranking of one or more other columns.15 Nov 24
Table.DuplicateColumnFunctionsDuplicates a column with the specified name15 Nov 24
Table.ExpandListColumnFunctionsGiven a column of lists in a table, create a copy of a row for each value in its list.15 Nov 24
Table.ExpandRecordColumnFunctionsExpands a column of records into columns with each of the values.15 Nov 24
Table.ExpandTableColumnFunctionsExpands a column of records or a column of tables into multiple columns in the containing table.15 Nov 24
Table.RemoveRowsWithErrorsFunctionsReturns a table with the rows removed from the input table that contain an error in at least one of the cells14 Nov 24
Table.ReplaceErrorValuesFunctionsReplaces the error values in the specified columns with the corresponding specified value.14 Nov 24
Table.SelectRowsWithErrorsFunctionsReturns a table with only those rows of the input table that contain an error in at least one of the cells14 Nov 24

October 2024

NameCategoryDescriptionLast update
Table.RemoveFirstNFunctionsReturns a table with the first count rows skipped.14 Oct 24
Table.RemoveLastNFunctionsReturns a table with the last N rows removed.14 Oct 24
Table.RemoveMatchingRowsFunctionsRemoves all occurrences of the specified rows from the table.14 Oct 24
Table.AlternateRowsFunctionsKeeps the initial offset then alternates taking and skipping the following rows.13 Oct 24
Table.DistinctFunctionsRemoves duplicate rows from the table.13 Oct 24
Table.InsertRowsFunctionsInserts a list of rows into the table at the specified position.13 Oct 24
Table.RepeatFunctionsRepeats the rows of the tables a specified number of times.13 Oct 24
Table.MaxFunctionsReturns the largest row or default value using the given criteria.12 Oct 24
Table.MaxNFunctionsReturns the largest row(s) using the given criteria.12 Oct 24
Table.MinFunctionsReturns the smallest row or a default value using the given criteria.12 Oct 24
Table.MinNFunctionsReturns the smallest row(s) using the given criteria.12 Oct 24
Table.RangeFunctionsReturns the rows beginning at the specified offset.12 Oct 24
Table.RemoveRowsFunctionsRemoves the specified number of rows.12 Oct 24
Table.FirstValueFunctionsReturns the first column of the first row of the table or a specified default value.10 Oct 24
Table.FillDownFunctionsPropagates the value of a previous cell to the null-valued cells below in the column.9 Oct 24
Table.FillUpFunctionsPropagates the value of a cell to the null-valued cells above in the column.9 Oct 24
Table.FirstFunctionsReturns the first row or a specified default value.9 Oct 24
Table.FirstNFunctionsReturns the first count rows specified.9 Oct 24
Table.LastFunctionsReturns the last row or a specified default value.9 Oct 24
Table.LastNFunctionsReturns the last specified number of rows.9 Oct 24
Value.ResourceExpressionFunctionsGenerates a record representing a given value’s resource expression.1 Oct 24

September 2024

NameCategoryDescriptionLast update
JoinKind.LeftSemiEnumerationsA left semi join returns all rows from the first table that have a match in the second table.8 Sep 24
JoinKind.RightSemiEnumerationsA right semi join returns all rows from the second table that have a match in the first table.8 Sep 24
Table.PartitionFunctionsPartitions the table into a list of tables based on the number of groups and column specified.2 Sep 24
Table.PartitionValuesFunctionsReturns information about how a table is partitioned.2 Sep 24
Table.RowCountFunctionsReturns the number of rows in the table.2 Sep 24
Table.SplitFunctionsSplits the specified table into a list of tables using the specified page size.2 Sep 24
Table.SplitAtFunctionsReturns a list containing the first count rows specified and the remaining rows.2 Sep 24
Table.ToColumnsFunctionsCreates a list of nested lists of column values from a table.1 Sep 24
Table.ToListFunctionsConverts a table into a list by applying the specified combining function to each row of values in the table.1 Sep 24
Table.ToRecordsFunctionsConverts a table to a list of records.1 Sep 24
Table.ToRowsFunctionsCreates a list of nested lists of row values from a table.1 Sep 24

August 2024

NameCategoryDescriptionLast update
Table.FromColumnsFunctionsCreates a table from a list of columns and specified values.30 Aug 24
Table.FromListFunctionsConverts a list into a table by applying the specified splitting function to each item in the list.30 Aug 24
Table.FromPartitionsFunctionsReturns a table that is the result of combining a set of partitioned tables.30 Aug 24
Table.FromRecordsFunctionsConverts a list of records into a table.30 Aug 24
Table.FromRowsFunctionsCreates a table from a list of row values and optional columns30 Aug 24
Table.FromValueFunctionsCreates a table with a column from the provided value(s).30 Aug 24
Table.UnpivotFunctionsTranslates a set of columns in a table into attribute-value pairs.29 Aug 24
Table.UnpivotOtherColumnsFunctionsTranslates all columns other than a specified set into attribute-value pairs.29 Aug 24

July 2024

NameCategoryDescriptionLast update
DateTime.IsInCurrentHourFunctionsIndicates whether this datetime occurs during the current hour.8 Jul 24
DateTime.IsInCurrentMinuteFunctionsIndicates whether this datetime occurs during the current minute.8 Jul 24
DateTime.IsInCurrentSecondFunctionsIndicates whether this datetime occurs during the current second.8 Jul 24
DateTime.IsInNextHourFunctionsIndicates whether this datetime occurs during the next hour8 Jul 24
DateTime.IsInNextMinuteFunctionsIndicates whether this datetime occurs during the next minute8 Jul 24
DateTime.IsInNextNHoursFunctionsIndicates whether this datetime occurs during the next number of hours8 Jul 24
DateTime.IsInNextNMinutesFunctionsIndicates whether this datetime occurs during the next number of minutes8 Jul 24
DateTime.IsInNextNSecondsFunctionsIndicates whether this datetime occurs during the next number of seconds8 Jul 24
DateTime.IsInNextSecondFunctionsIndicates whether this datetime occurs during the next second8 Jul 24
DateTime.IsInPreviousHourFunctionsIndicates whether this datetime occurs during the previous hour8 Jul 24
DateTime.IsInPreviousMinuteFunctionsIndicates whether this datetime occurs during the previous minute8 Jul 24
DateTime.IsInPreviousNHoursFunctionsIndicates whether this datetime occurs during the previous number of hours8 Jul 24
DateTime.IsInPreviousNMinutesFunctionsIndicates whether this datetime occurs during the previous number of minutes8 Jul 24
DateTime.IsInPreviousNSecondsFunctionsIndicates whether this datetime occurs during the previous number of seconds8 Jul 24
DateTime.IsInPreviousSecondFunctionsIndicates whether this datetime occurs during the previous second8 Jul 24
RankKind.OrdinalEnumerationsEvery item, even those that are identical, gets a unique rank. Duplicate values get consecutive rankings.8 Jul 24
Date.IsInCurrentDayFunctionsIndicates whether this date occurs during the current day.7 Jul 24
Date.IsInCurrentMonthFunctionsIndicates whether this date occurs during the current month.7 Jul 24
Date.IsInCurrentQuarterFunctionsIndicates whether this date occurs during the current quarter.7 Jul 24
Date.IsInCurrentWeekFunctionsIndicates whether this date occurs during the current week.7 Jul 24
Date.IsInCurrentYearFunctionsIndicates whether this date occurs during the current year.7 Jul 24
Date.IsInNextDayFunctionsIndicates whether this date occurs during the next day7 Jul 24
Date.IsInNextMonthFunctionsIndicates whether this date occurs during the next month7 Jul 24
Date.IsInNextNDaysFunctionsIndicates whether this date occurs during the next number of days7 Jul 24
Date.IsInNextNMonthsFunctionsIndicates whether this date occurs during the next number of months7 Jul 24
Date.IsInNextNQuartersFunctionsIndicates whether this date occurs during the next number of quarters7 Jul 24
Date.IsInNextNWeeksFunctionsIndicates whether this date occurs during the next number of weeks7 Jul 24
Date.IsInNextNYearsFunctionsIndicates whether this date occurs during the next number of years7 Jul 24
Date.IsInNextQuarterFunctionsIndicates whether this date occurs during the next quarter7 Jul 24
Date.IsInNextWeekFunctionsIndicates whether this date occurs during the next week7 Jul 24
Date.IsInNextYearFunctionsIndicates whether this date occurs during the next year7 Jul 24
Date.IsInPreviousDayFunctionsIndicates whether this date occurs during the previous day7 Jul 24
Date.IsInPreviousMonthFunctionsIndicates whether this date occurs during the previous month7 Jul 24
Date.IsInPreviousNDaysFunctionsIndicates whether this date occurs during the previous number of days7 Jul 24
Date.IsInPreviousNMonthsFunctionsIndicates whether this date occurs during the previous number of months7 Jul 24
Date.IsInPreviousNQuartersFunctionsIndicates whether this date occurs during the previous number of quarters7 Jul 24
Date.IsInPreviousNWeeksFunctionsIndicates whether this date occurs during the previous number of weeks7 Jul 24
Date.IsInPreviousNYearsFunctionsIndicates whether this date occurs during the previous number of years7 Jul 24
Date.IsInPreviousQuarterFunctionsIndicates whether this date occurs during the previous quarter7 Jul 24
Date.IsInPreviousWeekFunctionsIndicates whether this date occurs during the previous week7 Jul 24
Date.IsInPreviousYearFunctionsIndicates whether this date occurs during the previous year7 Jul 24
Date.IsInYearToDateFunctionsIndicates whether this date occurs during the current year and is on or before the current day.7 Jul 24
Date.IsLeapYearFunctionsIndicates whether this date falls in a leap year.7 Jul 24
#binaryFunctionsCreates a binary value from a list of numbers or a base 64 encoded text value.2 Jul 24
#dateFunctionsCreates a date value from whole numbers representing the year, month, and day.2 Jul 24
#datetimezoneFunctionsCreates a datetimezone value from numbers representing the year, month, day, hour, minute, (fractional) second, (fractional) offset-hours, and offset-minutes.2 Jul 24
#durationFunctionsCreates a duration value from numbers representing days, hours, minutes, and (fractional) seconds.2 Jul 24
#tableFunctionsCreates a table value from columns and rows.2 Jul 24
#timeFunctionsCreates a time value from numbers representing the hour, minute, and (fractional) second.2 Jul 24
Expression.ConstantFunctionsReturns the M source code representation of a constant value.2 Jul 24
Expression.EvaluateFunctionsReturns the result of evaluating an M expression.2 Jul 24
Expression.IdentifierFunctionsReturns the M source code representation of an identifier.2 Jul 24
Logical.FromFunctionsCreates a logical from the given value.2 Jul 24
Logical.FromTextFunctionsCreates a logical value from the text values “true” and “false”.2 Jul 24
Logical.ToTextFunctionsReturns the text “true” or “false” given a logical value.2 Jul 24
Time.EndOfHourFunctionsReturns the end of the hour.1 Jul 24
Time.FromFunctionsCreates a time from the given value.1 Jul 24
Time.FromTextFunctionsCreates a Time from local and universal, and custom Time formats.1 Jul 24
Time.StartOfHourFunctionsReturns the start of the hour.1 Jul 24
Time.ToRecordFunctionsReturns a record containing the Time value’s parts.1 Jul 24
Time.ToTextFunctionsReturns a textual representation of the time value.1 Jul 24

June 2024

NameCategoryDescriptionLast update
Text.PositionOfAnyFunctionsReturns the first position in the text value of any listed character (-1 if not found).18 Jun 24
Time.HourFunctionsReturns the hour component.15 Jun 24
Time.MinuteFunctionsReturns the minute component.15 Jun 24
Time.SecondFunctionsReturns the second component.15 Jun 24
DateTime.AddZoneFunctionsAdds timezone information to the datetime value.13 Jun 24
DateTime.DateFunctionsReturns the date component of the given date, datetime, or datetimezone value.13 Jun 24
DateTime.FixedLocalNowFunctionsReturns the current date and time in the local timezone13 Jun 24
Date.EndOfWeekFunctionsReturns the end of the week.12 Jun 24
Date.EndOfYearFunctionsReturns the end of the year.12 Jun 24
Date.StartOfDayFunctionsReturns the start of the day.12 Jun 24
Date.StartOfMonthFunctionsReturns the start of the month.12 Jun 24
Date.StartOfQuarterFunctionsReturns the start of the quarter.12 Jun 24
Date.StartOfWeekFunctionsReturns the start of the week.12 Jun 24
Date.StartOfYearFunctionsReturns the start of the year.12 Jun 24
Date.ToRecordFunctionsReturns a record containing parts of the date value.12 Jun 24
Date.WeekOfMonthFunctionsReturns a number from 1 to 6 indicating which week of the month this date falls in.12 Jun 24
Date.YearFunctionsReturns the year component.12 Jun 24
DateTime.FromFunctionsCreates a datetime from the given value.12 Jun 24
DateTime.FromFileTimeFunctionsCreates a datetime from a 64 bits long number.12 Jun 24
DateTime.FromTextFunctionsCreates a datetimezone from local and universal datetime formats.12 Jun 24
DateTime.TimeFunctionsReturns the time part of the given datetime value.12 Jun 24
DateTime.ToRecordFunctionsReturns a record containing the datetime value’s parts.12 Jun 24
Date.FromFunctionsCreates a date from the given value.11 Jun 24
Date.FromTextFunctionsCreates a Date from local, universal, and custom Date formats.11 Jun 24
Date.MonthFunctionsReturns the month component.11 Jun 24
Date.MonthNameFunctionsReturns the name of the month component.11 Jun 24
Date.QuarterOfYearFunctionsReturns a number indicating which quarter of the year the date falls in.11 Jun 24
Duration.FromFunctionsCreates a duration from the given value.11 Jun 24
Duration.FromTextFunctionsReturns a duration value from textual elapsed time forms (d.h:m:s).11 Jun 24
Duration.ToRecordFunctionsReturns a record containing the parts of the duration.11 Jun 24
Guid.FromFunctionsReturns a guid value from the given value.11 Jun 24
Record.AddFieldFunctionsAdds a field to a record.11 Jun 24
Record.CombineFunctionsCombines the records in the given list.11 Jun 24
Record.FieldFunctionsReturns the value of the specified field in a record.11 Jun 24
Record.FieldCountFunctionsReturns the number of fields in the record.11 Jun 24
Record.FieldNamesFunctionsReturns the names of the fields.11 Jun 24
Record.FieldOrDefaultFunctionsReturns the value of the specified field in a record or the default value if the field is not found.11 Jun 24
Record.FieldValuesFunctionsReturns a list of the field values.11 Jun 24
Record.FromListFunctionsReturns a record given a list of field values and a set of fields.11 Jun 24
Record.FromTableFunctionsCreates a record from a table of the form {[Name = name, Value = value]}.11 Jun 24
Record.HasFieldsFunctionsIndicates whether the record has the specified fields.11 Jun 24
Record.RemoveFieldsFunctionsRemoves the specified field(s) from the input record.11 Jun 24
Record.RenameFieldsFunctionsApplies rename(s) from a list in the form { old, new }.11 Jun 24
Record.ReorderFieldsFunctionsReorders the field(s) specified into the new order.11 Jun 24
Record.SelectFieldsFunctionsReturns a record that contains only the specified fields.11 Jun 24
Record.ToListFunctionsReturns a list of values containing the field values of the input record.11 Jun 24
Record.ToTableFunctionsReturns a table with each row being a field name and value of the input record.11 Jun 24
Record.TransformFieldsFunctionsReturns a record after applying specified transformations.11 Jun 24
Text.CombineFunctionsConcatenates a list of text values into one text value.11 Jun 24
Date.DayFunctionsReturns the day component.10 Jun 24
Date.DayOfWeekFunctionsReturns a number (from 0 to 6) indicating the day of the week of the provided value.10 Jun 24
Date.DayOfWeekNameFunctionsReturns the day of the week name.10 Jun 24
Date.DayOfYearFunctionsReturns a number from 1 to 366 representing the day of the year.10 Jun 24
Date.DaysInMonthFunctionsReturns a number from 28 to 31 indicating the number of days in the month.10 Jun 24
Date.AddDaysFunctionsAdds the specified days to the date.9 Jun 24
Date.AddMonthsFunctionsAdds the specified months to the date.9 Jun 24
Date.AddQuartersFunctionsAdds the specified quarters to the date.9 Jun 24
Date.AddWeeksFunctionsAdds the specified weeks to the date.9 Jun 24
Date.AddYearsFunctionsAdds the specified years to the date.9 Jun 24
Date.EndOfDayFunctionsReturns the end of the day.9 Jun 24
Date.EndOfMonthFunctionsReturns the end of the month.9 Jun 24
Date.EndOfQuarterFunctionsReturns the end of the quarter.9 Jun 24
Binary.FromTextFunctionsDecodes data from a text form into binary.8 Jun 24
Duration.DaysFunctionsReturns the days portion of a duration.8 Jun 24
Duration.HoursFunctionsReturns the hours portion of a duration.8 Jun 24
Duration.MinutesFunctionsReturns the minutes portion of a duration.8 Jun 24
Duration.SecondsFunctionsReturns the seconds portion of a duration.8 Jun 24
Duration.TotalDaysFunctionsReturns the total days this duration spans.8 Jun 24
Duration.TotalHoursFunctionsReturns the total hours this duration spans.8 Jun 24
Duration.TotalMinutesFunctionsReturns the total minutes this duration spans.8 Jun 24
Duration.TotalSecondsFunctionsReturns the total seconds this duration spans.8 Jun 24
List.ContainsAnyFunctionsIndicates where a list includes any of the values in another list.8 Jun 24
List.ModeFunctionsReturns the most frequent value in the list.8 Jun 24
List.ModesFunctionsReturns a list of the most frequent values in the list.8 Jun 24

May 2024

NameCategoryDescriptionLast update
List.RemoveItemsFunctionsRemoves items from list1 that are present in list.4 May 24
Table.GroupFunctionsGroups rows in the table that have the same key.4 May 24

April 2024

NameCategoryDescriptionLast update
Module.VersionsFunctionsReturns a record of module versions for the current module and its dependencies.30 Apr 24
SparkProtocol.AzureEnumerationsSpecifies the Azure protocol to connect to an instance of Spark.28 Apr 24
SparkProtocol.HTTPEnumerationsSpecifies the Standard protocol to connect to an instance of Spark.28 Apr 24
SparkProtocol.StandardEnumerationsSpecifies the Standard protocol to connect to an instance of Spark.28 Apr 24
List.MedianFunctionsReturns the median value in the list.25 Apr 24
List.AverageFunctionsReturns the average of the values24 Apr 24
List.ContainsFunctionsIndicates whether the list contains the value.24 Apr 24
List.ContainsAllFunctionsIndicates where a list includes all the values in another list.24 Apr 24
List.DatesFunctionsGenerates a list of date values given an initial value, count, and incremental duration value.24 Apr 24
List.IsDistinctFunctionsIndicates whether there are duplicates in the list.24 Apr 24
List.ProductFunctionsReturns the product of the numbers in the list.24 Apr 24
List.SumFunctionsReturns the sum of the items in the list.24 Apr 24
Table.CombineColumnsFunctionsCombines the specified columns into a new column using the specified combiner function.2 Apr 24

March 2024

NameCategoryDescriptionLast update
DateTimeZone.FixedLocalNowFunctionsReturns the current date & time in the local timezone8 Mar 24
DateTimeZone.FixedUtcNowFunctionsReturns the current date and time in UTC (the GMT timezone)8 Mar 24

January 2024

NameCategoryDescriptionLast update
Table.SelectRowsFunctionsSelects the rows that meet the condition function.4 Jan 24
Table.AddColumnFunctionsAdds a column with the specified name3 Jan 24
Table.CombineFunctionsReturns a table that is the result of merging a list of tables.3 Jan 24
GeographyPoint.FromFunctionsCreates a record representing a geographic point from parts.1 Jan 24
Geometry.FromWellKnownTextFunctionsTranslates text representing a geometric value in Well-Known Text (WKT) format into a structured record.1 Jan 24
Geometry.ToWellKnownTextFunctionsTranslates a structured geometric point value into its Well-Known Text (WKT) representation.1 Jan 24
GeometryPoint.FromFunctionsCreates a record representing a geometric point from parts.1 Jan 24

December 2023

NameCategoryDescriptionLast update
Geography.FromWellKnownTextFunctionsTranslates text representing a geographic value in Well-Known Text (WKT) format into a structured record.31 Dec 23
Geography.ToWellKnownTextFunctionsTranslates a structured geographic point value into its Well-Known Text (WKT) representation.31 Dec 23
Table.ColumnsOfTypeFunctionsReturns a list with the names of the columns that match the specified types.26 Dec 23
Table.CombineColumnsToRecordFunctionsCombines 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.20 Dec 23
Date.WeekOfYearFunctionsReturns a number from 1 to 54 indicating which week of the year this date falls in.18 Dec 23
List.CountFunctionsReturns the number of items in the list.15 Dec 23
List.NonNullCountFunctionsReturns the number of non-null items in the list.15 Dec 23
Table.TransformColumnTypesFunctionsApplies type transformation(s) of the form { column, type } using a specific culture.11 Dec 23
Value.VersionsFunctionsReturns a navigation table containing the available versions of value.10 Dec 23
Table.SortFunctionsSorts the table using one or more column names and comparison criteria.8 Dec 23
FacetsPagesType facets provide additional type information that can be used by external systems for improved data storage and handling.6 Dec 23
List.DistinctFunctionsReturns a list of values with duplicates removed.3 Dec 23
Binary.DecompressFunctionsDecompresses a binary value using the given compression type.2 Dec 23
BinaryFormat.ByteOrderFunctionsReturns a binary format with the byte order specified by a function.2 Dec 23
Cube.TransformFunctionsApplies a list of cube functions.2 Dec 23
List.PercentileFunctionsReturns one or more sample percentiles corresponding to the given probabilities.2 Dec 23
OData.FeedFunctionsReturns a table of OData feeds offered by an OData service.2 Dec 23
Odbc.DataSourceFunctionsReturns a table of SQL tables and views from the ODBC data source2 Dec 23
SapBusinessWarehouse.CubesFunctionsReturns the InfoCubes and queries in an SAP Business Warehouse system grouped by InfoArea.2 Dec 23
Table.FuzzyJoinFunctionsJoins the rows from the two tables that fuzzy match based on the given keys.2 Dec 23
Table.FuzzyNestedJoinFunctionsPerforms a fuzzy join between tables on supplied columns and produces the join result in a new column.2 Dec 23
Table.JoinFunctionsJoins the rows from the two tables that match based on the given keys.2 Dec 23
TextEncoding.AsciiEnumerationsUse to choose the ASCII binary form.2 Dec 23
TextEncoding.BigEndianUnicodeEnumerationsUse to choose the UTF16 big endian binary form.2 Dec 23
TextEncoding.UnicodeEnumerationsUse to choose the UTF16 little endian binary form.2 Dec 23
TextEncoding.Utf16EnumerationsUse to choose the UTF16 little endian binary form.2 Dec 23
TextEncoding.Utf8EnumerationsUse to choose the UTF8 binary form.2 Dec 23
TextEncoding.WindowsEnumerationsUse to choose the Windows binary form.2 Dec 23
WebAction.RequestFunctionsCreates an action that, when executed, will return the results of performing an HTTP request as a binary value.2 Dec 23

November 2023

NameCategoryDescriptionLast update
List.PositionOfAnyFunctionsReturns the first offset of a value in a list.28 Nov 23
List.ReplaceMatchingItemsFunctionsApplies each replacement of { old, new }.28 Nov 23
List.ReplaceRangeFunctionsReplaces count number of values starting at position with the replacement values.28 Nov 23
List.TransformFunctionsReturns a new list of values computed from this list.28 Nov 23
List.TransformManyFunctionsReturns a list whose elements are transformed from the input list using specified functions.28 Nov 23
Action.WithErrorContextNewThis function is intended for internal use only.24 Nov 23
AzureDataFactory.ActionsNewConnect to Azure Data Factory Service24 Nov 23
AzureDatabricksWorkspace.ActionsNewConnect to Azure Databricks workspace24 Nov 23
AzureKeyVault.ActionsNewConnect to Azure Keyvault Service24 Nov 23
AzureResourceGraph.QueryNew24 Nov 23
AzureSynapseWorkspace.ActionsNewConnect to Azure Synapse Service24 Nov 23
AzureTrino.ContentsNew24 Nov 23
Diagnostics.CorrelationIdNewReturns an opaque identifier to correlate incoming requests with outgoing ones.24 Nov 23
DremioCloud.DatabasesByServerV360NewReturns a table listing the datasets on the specified server on Dremio Cloud24 Nov 23
EmplifiMetrics.ContentsNew24 Nov 23
Function.InvokeWithErrorContextNewThis function is intended for internal use only.24 Nov 23
IoTHub.ContentsNewUsed to connect to Azure IoT Hub.24 Nov 23
MongoDBAtlasForPipeline.DatabaseNewConnect to MongoDB Atlas For Pipeline24 Nov 23
MongoDBForPipeline.ContentsNewUsed to connect to MongoDB For Pipeline.24 Nov 23
Parquet.MetadataNewThis function is intended for internal use only.24 Nov 23
PlanviewOKR.ContentsNewEnter the URL of your Planview OKR account.24 Nov 23
PowerBIDatasets.ActionsNewConnect to PowerBIDatasets24 Nov 23
Table.WithErrorContextNewThis function is intended for internal use only.24 Nov 23
Data TypesPagesThis article delves into data types. It shows the available types, their characteristics, and how to use them.22 Nov 23
Table.BufferFunctionsBuffers a table in memory, isolating it from external changes during evaluation.18 Nov 23
Type.IsNullableFunctionsReturns true if a type is a nullable type; otherwise, false.15 Nov 23
Type.IsOpenRecordFunctionsReturns whether a record type is open.15 Nov 23
Type.ListItemFunctionsReturns an item type from a list type.15 Nov 23
Type.NonNullableFunctionsReturns the non nullable type from a type.15 Nov 23
Type.OpenRecordFunctionsReturns an opened version of the given record type (or the same type, if it is already open).15 Nov 23
Type.RecordFieldsFunctionsReturns a record describing the fields of a record type with each field of the returned record type having a corresponding name and a value.15 Nov 23
Type.ReplaceTableKeysFunctionsReturns a new table type with all keys replaced by the specified list of keys.15 Nov 23
Type.TableColumnFunctionsReturns the type of a column in a table.15 Nov 23
Type.TableKeysFunctionsReturns the possibly empty list of keys for the given table type.15 Nov 23
Type.TableRowFunctionsReturns the row type of the table type.15 Nov 23
Type.UnionFunctionsReturns the union of a list of types.15 Nov 23
Type.ReplaceFacetsFunctionsReplaces the facets of a type.13 Nov 23
Type.AddTableKeyFunctionsAdds a key to the given table type.11 Nov 23
Type.ClosedRecordFunctionsReturns a closed version of the given record type (or the same type, if it is already closed).11 Nov 23
Type.FacetsFunctionsReturns the facets of a type.11 Nov 23
Type.ForFunctionFunctionsReturns a type that represents functions with specific parameter and return type constraints.11 Nov 23
Type.ForRecordFunctionsReturns a type that represents records with specific type constraints on fields.11 Nov 23
Type.FunctionParametersFunctionsReturns a record with field values set to the name of the parameters of a function type, and their values set to their corresponding types.11 Nov 23
Type.FunctionRequiredParametersFunctionsReturns a number indicating the minimum number of parameters required to invoke the type of function.11 Nov 23
Type.FunctionReturnFunctionsReturns a type returned by a function type.11 Nov 23

October 2023

NameCategoryDescriptionLast update
Combiner.CombineTextByLengthsFunctionsReturns a function that combines a list of text into a single text using the specified lengths.30 Oct 23
Comparer.FromCultureFunctionsReturns a comparer function given the culture and a logical value for case sensitivity for the comparison.27 Oct 23
Date.ToTextFunctionsReturns a textual representation of the date value.25 Oct 23
DateTime.ToTextFunctionsReturns a textual representation of the datetime value.25 Oct 23
DateTimeZone.ToTextFunctionsReturns a textual representation of the datetimezone value.25 Oct 23
Number.ToTextFunctionsFormats the given number as text.25 Oct 23
Table.ReplaceValueFunctionsReplaces one value with another in the specified columns.23 Oct 23
List.FirstNFunctionsReturns the first set of items in the list by specifying how many items to return or a qualifying condition.20 Oct 23
Error MessagesPagesThis article addresses the most common error messages in Power Query.16 Oct 23
OperatorsPagesThis article describes the operators used in the Power Query M language.1 Oct 23

September 2023

NameCategoryDescriptionLast update
Combiner.CombineTextByPositionsFunctionsReturns a function that combines a list of text into a single text using the specified positions.22 Sep 23
Combiner.CombineTextByRangesFunctionsReturns a function that combines a list of text into a single text using the specified positions and lengths.22 Sep 23
Sql.DatabaseFunctionsReturns a table of SQL tables, views, and stored functions from the SQL Server database.20 Sep 23
Table.StopFoldingFunctionsPrevents any downstream operations from being run against the original source of the data.20 Sep 23
Value.NativeQueryFunctionsEvaluates a query against a target.20 Sep 23
WebMethod.DeleteEnumerationsSpecifies the DELETE method for HTTP.20 Sep 23
WebMethod.GetEnumerationsSpecifies the GET method for HTTP.20 Sep 23
WebMethod.HeadEnumerationsSpecifies the HEAD method for HTTP.20 Sep 23
WebMethod.PatchEnumerationsSpecifies the PATCH method for HTTP.20 Sep 23
WebMethod.PostEnumerationsSpecifies the POST method for HTTP.20 Sep 23
WebMethod.PutEnumerationsSpecifies the PUT method for HTTP.20 Sep 23
LimitClauseKind.AnsiSql2008EnumerationsThis SQL dialect supports an ANSI SQL-compatible LIMIT N ROWS specifier to limit the number of rows returned.13 Sep 23
LimitClauseKind.LimitEnumerationsThis SQL dialect supports a LIMIT specifier to limit the number of rows returned.13 Sep 23
LimitClauseKind.LimitOffsetEnumerationsThis SQL dialect supports LIMIT and OFFSET specifiers to limit the number of rows returned.13 Sep 23
LimitClauseKind.NoneEnumerationsThis SQL dialect does not support a limit clause.13 Sep 23
LimitClauseKind.TopEnumerationsThis SQL dialect supports a TOP specifier to limit the number of rows returned.13 Sep 23
List.InsertRangeFunctionsInserts values into a list at the given index.12 Sep 23
List.UnionFunctionsReturns the union of the list values found in the input.6 Sep 23
List.CombineFunctionsReturns a single list by combining multiple lists.5 Sep 23

August 2023

NameCategoryDescriptionLast update
List.PositionOfFunctionsReturns the offset(s) of a value in a list.30 Aug 23
Table.TransformColumnsFunctionsTransforms the values of one or more columns.30 Aug 23
List.DifferenceFunctionsReturns the difference of the two given lists.29 Aug 23
List.RemoveNullsFunctionsRemoves all “null” values from the specified list.29 Aug 23
List.RemoveRangeFunctionsRemoves count number of values starting at the specified position.29 Aug 23
List.SkipFunctionsReturns a list that skips the specified number of elements at the beginning of the list.29 Aug 23
List.IntersectFunctionsReturns the intersection of the list values found in the input.28 Aug 23
List.RemoveMatchingItemsFunctionsRemoves all occurrences of the input values.28 Aug 23
List.LastFunctionsReturns the last value of the list or the specified default if empty.27 Aug 23
List.LastNFunctionsReturns the last value in the list27 Aug 23
List.MaxFunctionsReturns the maximum value or the default value for an empty list.27 Aug 23
List.MaxNFunctionsReturns the maximum value(s) in the list27 Aug 23
List.MinFunctionsReturns the minimum value or the default value for an empty list.27 Aug 23
List.MinNFunctionsReturns the minimum value(s) in the list27 Aug 23
List.RangeFunctionsReturns a subset of the list beginning at an offset.27 Aug 23
List.RemoveFirstNFunctionsReturns a list that skips the specified number of elements at the beginning of the list.27 Aug 23
List.RemoveLastNFunctionsReturns a list that removes the specified number of elements from the end of the list.27 Aug 23
List.FirstFunctionsReturns the first value of the list or the specified default if empty.25 Aug 23
List.NumbersFunctionsReturns a list of numbers given an initial value, count, and optional increment value.25 Aug 23
List.RandomFunctionsReturns a list of random numbers.25 Aug 23
List.RepeatFunctionsReturns a list that is count repetitions of the original list.25 Aug 23
List.SplitFunctionsSplits the specified list into a list of lists using the specified page size.25 Aug 23
List.ZipFunctionsReturns a list of lists by combining items at the same position in multiple lists.25 Aug 23
Diagnostics.ActivityIdFunctionsReturns an opaque identifier for the currently-running evaluation.24 Aug 23
Diagnostics.TraceFunctionsWrites a trace entry, if tracing is enabled, and returns the value.24 Aug 23
Error.RecordFunctionsReturns an error record from the provided text values for reason, message and detail.24 Aug 23
List.ReverseFunctionsReverses the order of values in the list.24 Aug 23
TraceLevel.CriticalEnumerationsSpecifies Critical trace level.24 Aug 23
TraceLevel.ErrorEnumerationsSpecifies Error trace level.24 Aug 23
TraceLevel.InformationEnumerationsSpecifies Information trace level.24 Aug 23
TraceLevel.VerboseEnumerationsSpecifies Verbose trace level.24 Aug 23
TraceLevel.WarningEnumerationsSpecifies Warning trace level.24 Aug 23
SapHanaRangeOperator.EqualsEnumerations‘Equals’ range operator for SAP HANA input parameters.18 Aug 23
SapHanaRangeOperator.GreaterThanEnumerations‘Greater than’ range operator for SAP HANA input parameters.18 Aug 23
SapHanaRangeOperator.GreaterThanOrEqualsEnumerations‘Greater than or equals’ range operator for SAP HANA input parameters.18 Aug 23
SapHanaRangeOperator.LessThanEnumerations‘Less than’ range operator for SAP HANA input parameters.18 Aug 23
SapHanaRangeOperator.LessThanOrEqualsEnumerations‘Less than or equals’ range operator for SAP HANA input parameters.18 Aug 23
SapHanaRangeOperator.NotEqualsEnumerations‘Not equals’ range operator for SAP HANA input parameters.18 Aug 23
Number.BitwiseAndFunctionsReturns the result of performing a bitwise “And” operation between the two inputs.16 Aug 23
Number.BitwiseNotFunctionsReturns a byte where each bit is the opposite of the input.16 Aug 23
Number.BitwiseOrFunctionsReturns the result of performing a bitwise “Or” between the two inputs.16 Aug 23
Number.BitwiseShiftLeftFunctionsShifts the bits set to the left.16 Aug 23
Number.BitwiseShiftRightFunctionsShifts the bits set to the right.16 Aug 23
Number.BitwiseXorFunctionsReturns the result of performing a bitwise “XOR” (Exclusive-OR) between the two inputs.16 Aug 23
Comparer.EqualsFunctionsReturns a logical value based on the equality check over the two given values.13 Aug 23
Comparer.OrdinalFunctionsReturns a comparer function which uses Ordinal rules to compare values.13 Aug 23
Comparer.OrdinalIgnoreCaseFunctionsReturns a case-insensitive comparer function which uses Ordinal rules to compare values.13 Aug 23
SapHanaDistribution.AllEnumerations‘All’ distribution option for SAP HANA.10 Aug 23
SapHanaDistribution.ConnectionEnumerations‘Connection’ distribution option for SAP HANA.10 Aug 23
SapHanaDistribution.OffEnumerations‘Off’ distribution option for SAP HANA.10 Aug 23
SapHanaDistribution.StatementEnumerations‘Statement’ distribution option for SAP HANA.10 Aug 23
Binary.ToTextFunctionsEncodes binary data into a text form.5 Aug 23
Splitter.SplitByNothingFunctionsReturns a function that does no splitting, returning its argument as a single element list.5 Aug 23
Splitter.SplitTextByAnyDelimiterFunctionsReturns a function that splits text into a list of text at any of the specified delimiters.5 Aug 23
Splitter.SplitTextByCharacterTransitionFunctionsReturns a function that splits text into a list of text according to a transition from one kind of character to another5 Aug 23
Duration.ToTextFunctionsReturns the text of the form “d.h:m:s”.1 Aug 23
Table.TransposeFunctionsMakes columns into rows and rows into columns.1 Aug 23

July 2023

NameCategoryDescriptionLast update
List.AccumulateFunctionsAccumulates a summary value from the items in the list.21 Jul 23
List.AllTrueFunctionsReturns true if all expressions are true.21 Jul 23
List.AlternateFunctionsReturns a list comprised of all the odd numbered offset elements in a list.21 Jul 23
Text.NewGuidFunctionsReturns a new, random globally unique identifier (GUID).21 Jul 23
Character.FromNumberFunctionsConverts the number to its character value.20 Jul 23
Character.ToNumberFunctionsConverts a character to its number value.20 Jul 23
Combiner.CombineTextByDelimiterFunctionsReturns a function that combines a list of text values into a single text value using the specified delimiter.15 Jul 23
Combiner.CombineTextByEachDelimiterFunctionsReturns a function that combines a list of text into a single text using each specified delimiter in sequence.15 Jul 23
BinaryEncoding.Base64EnumerationsConstant to use as the encoding type when base-64 encoding is required.12 Jul 23
BinaryEncoding.HexEnumerationsConstant to use as the encoding type when hexadecimal encoding is required.12 Jul 23
BinaryOccurrence.OptionalEnumerationsThe item is expected to appear zero or one time in the input.12 Jul 23
BinaryOccurrence.RepeatingEnumerationsThe item is expected to appear zero or more times in the input.12 Jul 23
BinaryOccurrence.RequiredEnumerationsThe item is expected to appear once in the input.12 Jul 23
DateTime.LocalNowFunctionsReturns the current date and time in the local timezone.10 Jul 23
DateTimeZone.FromFunctionsCreates a datetimezone from the given value.10 Jul 23
DateTimeZone.FromFileTimeFunctionsCreates a datetimezone from a 64 bits long number.10 Jul 23
DateTimeZone.FromTextFunctionsCreates a datetimezone from local, universal, and custom datetimezone formats.10 Jul 23
DateTimeZone.LocalNowFunctionsReturns the current date & time in the local timezone.10 Jul 23
DateTimeZone.RemoveZoneFunctionsRemoves timezone information from the given datetimezone value.10 Jul 23
DateTimeZone.SwitchZoneFunctionsChanges the timezone of the value.10 Jul 23
DateTimeZone.ToLocalFunctionsConverts the timezone component to the local timezone.10 Jul 23
DateTimeZone.ToRecordFunctionsReturns a record containing the datetimezone value’s parts.10 Jul 23
DateTimeZone.ToUtcFunctionsConverts the timezone component to UTC timezone.10 Jul 23
DateTimeZone.UtcNowFunctionsReturns the current date and time in UTC (the GMT timezone).10 Jul 23
DateTimeZone.ZoneHoursFunctionsChanges the timezone of the value.10 Jul 23
DateTimeZone.ZoneMinutesFunctionsChanges the timezone of the value.10 Jul 23
Function.InvokeAfterFunctionsInvokes the given function after the specified duration has passed.6 Jul 23
Table.SkipFunctionsReturns a table with the first count rows skipped.6 Jul 23
Number.FromFunctionsCreates a number from the given value.3 Jul 23
Text.InferNumberTypeFunctionsInfers the granular number type (Int64.Type, Double.Type, and so on) of a number encoded in text.3 Jul 23

June 2023

NameCategoryDescriptionLast update
BufferMode.DelayedEnumerationsThe 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.28 Jun 23
BufferMode.EagerEnumerationsThe entire value is immediately buffered in memory before continuing.28 Jun 23
ByteOrder.BigEndianEnumerationsA possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The most significant byte appears first in Big Endian byte order.28 Jun 23
ByteOrder.LittleEndianEnumerationsA possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The least significant byte appears first in Little Endian byte order.28 Jun 23
Compression.BrotliEnumerationsThe compressed data is in the ‘Brotli’ format.28 Jun 23
Compression.DeflateEnumerationsThe compressed data is in the ‘Deflate’ format.28 Jun 23
Compression.GZipEnumerationsThe compressed data is in the ‘GZip’ format.28 Jun 23
Compression.LZ4EnumerationsThe compressed data is in the ‘LZ4’ format.28 Jun 23
Compression.NoneEnumerationsThe data is uncompressed.28 Jun 23
Compression.SnappyEnumerationsThe compressed data is in the ‘Snappy’ format.28 Jun 23
Compression.ZstandardEnumerationsThe compressed data is in the ‘Zstandard’ format.28 Jun 23
CsvStyle.QuoteAfterDelimiterEnumerationsQuotes in a field are only significant immediately following the delimiter.28 Jun 23
CsvStyle.QuoteAlwaysEnumerationsQuotes in a field are always significant regardless of where they appear.28 Jun 23
Lines.FromTextFunctionsConverts a text value to a list of text values split at lines breaks28 Jun 23
Table.NestedJoinFunctionsPerforms a join between tables on supplied columns and produces the join result in a new column.28 Jun 23
Text.ContainsFunctionsReturns whether the text contains the substring.28 Jun 23
Text.EndsWithFunctionsIndicates whether the text ends in the specified value.28 Jun 23
Text.FromFunctionsCreates a text value from the given value.28 Jun 23
Text.LengthFunctionsReturns the number of characters.28 Jun 23
Text.PositionOfFunctionsReturns the first position of the value (-1 if not found).28 Jun 23
Text.ReplaceFunctionsReplaces all occurrences of the given substring in the text.28 Jun 23
Text.ReplaceRangeFunctionsRemoves a range of characters and inserts a new value at a specified position.28 Jun 23
Text.StartsWithFunctionsIndicates whether the text starts with a specified value.28 Jun 23
Text.CleanFunctionsReturns the text value with all control characters removed.27 Jun 23
Text.FormatFunctionsReturns formatted text from a format string and arguments.27 Jun 23
Text.RepeatFunctionsReturns a text value composed of the input text repeated a specified number of times.27 Jun 23
Text.ReverseFunctionsReverses the provided text27 Jun 23
Text.SplitFunctionsSplits text into a list of text values based upon a specified delimiter.27 Jun 23
Text.SplitAnyFunctionsReturns a list of text values, split on any of the characters in the delimiter.27 Jun 23
Text.ToListFunctionsReturns a list of character values from the given text value.27 Jun 23
Text.TrimFunctionsRemoves all leading and trailing whitespace.27 Jun 23
Text.UpperFunctionsConverts all characters to uppercase.25 Jun 23
Day.FridayEnumerationsRepresents Friday.24 Jun 23
Day.MondayEnumerationsRepresents Monday.24 Jun 23
Day.SaturdayEnumerationsRepresents Saturday.24 Jun 23
Day.SundayEnumerationsRepresents Sunday.24 Jun 23
Day.ThursdayEnumerationsRepresents Thursday.24 Jun 23
Day.TuesdayEnumerationsRepresents Tuesday.24 Jun 23
Day.WednesdayEnumerationsRepresents Wednesday.24 Jun 23
ExtraValues.ErrorEnumerationsIf the splitter function returns more columns than the table expects, an error should be raised.24 Jun 23
ExtraValues.IgnoreEnumerationsIf the splitter function returns more columns than the table expects, they should be ignored.24 Jun 23
ExtraValues.ListEnumerationsIf the splitter function returns more columns than the table expects, they should be collected into a list.24 Jun 23
RankKind.CompetitionEnumerationsIdentical 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.24 Jun 23
RankKind.DenseEnumerationsIdentical 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.24 Jun 23
RelativePosition.FromEndEnumerationsIndicates indexing should be done from the end of the input.24 Jun 23
RelativePosition.FromStartEnumerationsIndicates indexing should be done from the start of the input.24 Jun 23
RoundingMode.AwayFromZeroEnumerationsRound away from zero when there is a tie between the possible numbers to round to.24 Jun 23
RoundingMode.DownEnumerationsRound down when there is a tie between the possible numbers to round to.24 Jun 23
RoundingMode.ToEvenEnumerationsRound to the nearest even number when there is a tie between the possible numbers to round to.24 Jun 23
RoundingMode.TowardZeroEnumerationsRound toward zero when there is a tie between the possible numbers to round to.24 Jun 23
RoundingMode.UpEnumerationsRound up when there is a tie between the possible numbers to round to.24 Jun 23
SapBusinessWarehouseExecutionMode.BasXmlEnumerations‘bXML flattening mode’ option for MDX execution in SAP Business Warehouse.24 Jun 23
SapBusinessWarehouseExecutionMode.BasXmlGzipEnumerations‘Gzip compressed bXML flattening mode’ option for MDX execution in SAP Business Warehouse. Recommended for low latency or high volume queries.24 Jun 23
SapBusinessWarehouseExecutionMode.DataStreamEnumerations‘DataStream flattening mode’ option for MDX execution in SAP Business Warehouse.24 Jun 23
ODataOmitValues.NullsEnumerationsAllows the OData service to omit null values.22 Jun 23
Order.AscendingEnumerationsSorts the values in ascending order.22 Jun 23
Order.DescendingEnumerationsSorts the values in descending order.22 Jun 23
PercentileMode.ExcelExcEnumerationsWhen interpolating values for List.Percentile, use a method compatible with Excel’s PERCENTILE.EXC.22 Jun 23
PercentileMode.ExcelIncEnumerationsWhen interpolating values for List.Percentile, use a method compatible with Excel’s PERCENTILE.INC.22 Jun 23
PercentileMode.SqlContEnumerationsWhen interpolating values for List.Percentile, use a method compatible with SQL Server’s PERCENTILE_CONT.22 Jun 23
PercentileMode.SqlDiscEnumerationsWhen interpolating values for List.Percentile, use a method compatible with SQL Server’s PERCENTILE_DISC.22 Jun 23
Precision.DecimalEnumerationsAn optional parameter for the built-in arthimetic operators to specify decimal precision.22 Jun 23
Precision.DoubleEnumerationsAn optional parameter for the built-in arthimetic operators to specify double precision.22 Jun 23
QuoteStyle.CsvEnumerationsQuote characters indicate the start of a quoted string. Nested quotes are indicated by two quote characters.22 Jun 23
QuoteStyle.NoneEnumerationsQuote characters have no significance.22 Jun 23
Table.ProfileFunctionsReturns a profile of the columns of a table.22 Jun 23
Text.LowerFunctionsConverts all characters to lowercase.22 Jun 23
Text.ProperFunctionsCapitalizes the first letter of each word.22 Jun 23
List.SelectFunctionsReturns a list of values that match the condition.20 Jun 23
RowExpression.FromFunctionsReturns the abstract syntax tree (AST) for the body of a function.20 Jun 23
Text.AtFunctionsReturns the character at the specified position.20 Jun 23
Text.EndFunctionsReturns the last characters of the text.20 Jun 23
Text.InsertFunctionsInserts one text value into another at a given position.20 Jun 23
Text.MiddleFunctionsReturns the substring up to a specific length.20 Jun 23
Text.PadEndFunctionsReturns text of a specified length by padding the end of the given text.20 Jun 23
Text.PadStartFunctionsReturns text of a specified length by padding the start of the given text.20 Jun 23
Text.RangeFunctionsReturns the substring found at offset.20 Jun 23
Text.RemoveFunctionsRemoves all occurrences of the given character or list of characters from the input text value.20 Jun 23
Text.RemoveRangeFunctionsRemoves a count of characters starting at the given offset20 Jun 23
Text.SelectFunctionsSelects all occurrences of the given character or list of characters from the input text value.20 Jun 23
Text.StartFunctionsReturns the start of the text.20 Jun 23
Text.TrimEndFunctionsRemoves all trailing whitespace.20 Jun 23
Text.TrimStartFunctionsRemoves all leading whitespace.20 Jun 23
#datetimeFunctionsCreates a datetime value from numbers representing the year, month, day, hour, minute, and (fractional) second.15 Jun 23
Number.RoundFunctionsReturns the rounded number11 Jun 23
SapHana.DatabaseFunctionsReturns the packages in an SAP HANA database.11 Jun 23
Text.AfterDelimiterFunctionsReturns the portion of text after the specified delimiter11 Jun 23
Text.BeforeDelimiterFunctionsReturns the portion of text before the specified delimiter11 Jun 23
Text.BetweenDelimitersFunctionsReturns the portion of text between the specified startDelimiter and endDelimiter11 Jun 23
GroupKind.GlobalEnumerationsA global group is formed from all rows in an input table with the same key value.10 Jun 23
GroupKind.LocalEnumerationsA 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.10 Jun 23
JoinAlgorithm.DynamicEnumerationsAutomatically chooses a join algorithm based on inspecting the initial rows and metadata of both tables.10 Jun 23
JoinAlgorithm.LeftHashEnumerationsBuffers 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.10 Jun 23
JoinAlgorithm.LeftIndexEnumerationsIn 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.10 Jun 23
JoinAlgorithm.PairwiseHashEnumerationsBuffers 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.10 Jun 23
JoinAlgorithm.RightHashEnumerationsBuffers 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.10 Jun 23
JoinAlgorithm.RightIndexEnumerationsIn 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.10 Jun 23
JoinAlgorithm.SortMergeEnumerationsPerforms 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.10 Jun 23
JoinKind.FullOuterEnumerationsA 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.10 Jun 23
JoinKind.InnerEnumerationsThe 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.10 Jun 23
JoinKind.LeftAntiEnumerationsA left anti join returns that all rows from the first table which do not have a match in the second table.10 Jun 23
JoinKind.LeftOuterEnumerationsA left outer join ensures that all rows of the first table appear in the result.10 Jun 23
JoinKind.RightAntiEnumerationsA right anti join returns that all rows from the second table which do not have a match in the first table.10 Jun 23
JoinKind.RightOuterEnumerationsA right outer join ensures that all rows of the second table appear in the result.10 Jun 23

May 2023

NameCategoryDescriptionLast update
MissingField.ErrorEnumerationsAn optional parameter in record and table functions indicating that missing fields should result in an error. (This is the default parameter value.)30 May 23
MissingField.IgnoreEnumerationsAn optional parameter in record and table functions indicating that missing fields should be ignored.30 May 23
MissingField.UseNullEnumerationsAn optional parameter in record and table functions indicating that missing fields should be included as null values.30 May 23
Occurrence.AllEnumerationsA list of positions of all occurrences of the found values is returned.30 May 23
Occurrence.FirstEnumerationsThe position of the first occurrence of the found value is returned.30 May 23
Occurrence.LastEnumerationsThe position of the last occurrence of the found value is returned.30 May 23
Binary.CompressFunctionsCompresses a binary value using the given compression type.25 May 23
BinaryFormat.GroupFunctionsReturns a binary format that reads a group of items.25 May 23
Table.PivotFunctionsGiven a pair of columns representing attribute-value pairs, rotates the data in the attribute column into a column headings.25 May 23
List.GenerateFunctionsGenerates a list of values.20 May 23
List.SortFunctionsSorts a list of data according to the criteria specified.20 May 23

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy