Power Query Functions

Power Query is an amazing tool when it comes to extracting data from multiple different sources and then cleaning that data within the Power Query Editor.

While a lot can be done with the user interface in the Power Query editor, the real magic is happening behind the scenes, where Power Query is using some amazing built-in functions to transform your data.

As of writing this article, there are 850+ Power Query functions (and this list keeps getting longer).

Getting a List of All Power Query Functions

Here is a cool trick that will give you a list of all the Power Query functions.

1. Open a blank query in Power Query Editor.
2. In the formula bar, enter the following keyword:

=#shared

3. Press the Enter key

As soon as you do this, Power Query will give you a list of all the functions available for you.

All the function names are mentioned in the first column. To get more information on each function, you can click on the text function in the second column.

If you want to load this list of Power Query functions into Excel, click on the Convert into Table option in the Convert tab, and then Close and Load this query to get a table of all these functions in a worksheet.

Power Query Functions List

Here’s the list of all the Power Query functions that I got by using the shared keyword.

List functions

Power Query Function Name	Description
List.NonNullCount	Returns the number of non-null values in a list.
List.MatchesAll	Returns true if all items in a list satisfy the given condition function.
List.MatchesAny	Returns true if at least one item in a list satisfies the given condition function.
List.Range	Returns a subset of a list starting at a given offset, optionally limited to a specified count of items.
List.RemoveItems	Removes all items from a list that also appear in a second list.
List.ReplaceValue	Replaces occurrences of a specified value in a list with a new value.
List.FindText	Returns a list of items from a text list that contain the given text string.
List.RemoveLastN	Removes the last N items from a list.
List.RemoveFirstN	Removes the first N items from a list.
List.Count	Returns the number of items in a list.
List.Distinct	Removes duplicate values from a list, returning only distinct items.
List.FirstN	Returns the first N items from a list.
List.IsEmpty	Returns true if a list contains no items.
List.LastN	Returns the last N items from a list.
List.Select	Returns a new list containing only the items that satisfy the given condition function.
List.Skip	Returns a list with the first N items removed.
List.Sort	Sorts a list using one or more comparison criteria.
List.Transform	Applies a transform function to each item in a list and returns the resulting list.
List.TransformMany	Projects each item in a list to a new list using a collection selector, then flattens the results into a single list.
List.Type	Returns the type of a list value.
List.Contains	Returns true if a list contains the specified value.
List.Difference	Returns items from the first list that do not appear in the second list.
List.First	Returns the first item of a list, or an optional default value if the list is empty.
List.Generate	Generates a list by repeatedly applying a next function starting from an initial value, while a condition function returns true.
List.Intersect	Returns items that appear in all lists in a given list of lists.
List.IsDistinct	Returns true if a list contains no duplicate values.
List.Last	Returns the last item of a list, or an optional default value if the list is empty.
List.RemoveMatchingItems	Removes all items from a list that match any item in a second list.
List.RemoveNulls	Removes all null values from a list.
List.Repeat	Repeats the contents of a list a specified number of times.
List.ReplaceMatchingItems	Replaces items in a list according to a set of substitution pairs.
List.Reverse	Returns a list with the items in reverse order.
List.Single	Returns the single item in a list, or throws an error if the list contains more or fewer than one item.
List.SingleOrDefault	Returns the single item in a list, or a default value if the list is empty, and throws an error if it contains more than one item.
List.Union	Returns a list of distinct values from all lists in a given list of lists.
List.Accumulate	Reduces a list to a single value by applying an accumulator function to each item, starting from an initial seed value.
List.Buffer	Buffers a list in memory so that subsequent evaluations read from the in-memory copy rather than re-evaluating the source.
List.Combine	Concatenates multiple lists into a single list.
List.ContainsAll	Returns true if a list contains every value in a second list.
List.ContainsAny	Returns true if a list contains at least one value from a second list.
List.InsertRange	Inserts a list of values into another list at a specified index position.
List.Max	Returns the maximum value in a list.
List.MaxN	Returns the N largest values from a list.
List.Min	Returns the minimum value in a list.
List.MinN	Returns the N smallest values from a list.
List.PositionOf	Returns the zero-based index of the first occurrence of a value in a list.
List.PositionOfAny	Returns the zero-based index of the first occurrence of any value from a search list.
List.Positions	Returns a list of zero-based indexes for each item in a list.
List.RemoveRange	Removes a specified number of items from a list starting at a given index.
List.ReplaceRange	Replaces a range of items in a list with items from a replacement list.
List.Alternate	Returns a new list by alternately including and excluding items based on a specified offset and count pattern.
List.Zip	Combines multiple lists by pairing items at the same position into sublists.
List.Split	Splits a list into a list of lists, each of a specified page size.
List.Average	Returns the arithmetic mean of a list of numbers.
List.Covariance	Returns the population covariance between two lists of numbers.
List.Median	Returns the median value of a list of numbers.
List.Mode	Returns the most frequently occurring value in a list.
List.Modes	Returns all values that occur most frequently in a list.
List.Percentile	Returns the value at a specified percentile rank from a list of numbers.
List.Product	Returns the product of all numbers in a list.
List.Sum	Returns the sum of all numbers in a list.
List.StandardDeviation	Returns the sample standard deviation of a list of numbers.
List.Numbers	Generates a list of numbers starting from an initial value, incrementing by a given step, for a specified count.
List.Times	Generates a list of time values starting from an initial time, incrementing by a given duration, for a specified count.
List.Dates	Generates a list of date values starting from an initial date, incrementing by a given duration, for a specified count.
List.DateTimes	Generates a list of datetime values starting from an initial datetime, incrementing by a given duration, for a specified count.
List.DateTimeZones	Generates a list of datetimezone values starting from an initial datetimezone, incrementing by a given duration, for a specified count.
List.Durations	Generates a list of duration values starting from an initial duration, incrementing by a given step, for a specified count.
List.Random	Generates a list of random numbers between 0 and 1 of the specified count.
List.AllTrue	Returns true if all values in a list are true.
List.AnyTrue	Returns true if at least one value in a list is true.
List.ConformToPageReader	Transforms a list to match the structure expected by a page reader, used internally for streaming large list results.

Table functions

Power Query Function Name	Description
Table.ColumnCount	Returns the number of columns in a table.
Table.AlternateRows	Returns a table containing alternating rows from a table, starting at a specified offset and keeping and skipping the specified number of rows in turn.
Table.InsertRows	Returns a table with one or more rows inserted at a specified position.
Table.LastN	Returns the last N rows of a table.
Table.Last	Returns the last row of a table as a record, or a default value if the table is empty.
Table.MatchesAllRows	Returns true if every row in a table satisfies the given condition.
Table.MatchesAnyRows	Returns true if at least one row in a table satisfies the given condition.
Table.Partition	Splits a table into a list of tables based on a partition function and the specified number of groups.
Table.Range	Returns a table containing a specified number of rows starting at a given offset.
Table.RemoveRows	Returns a table with a specified number of rows removed starting at a given offset.
Table.Repeat	Returns a table whose rows are the original table’s rows repeated a given number of times.
Table.ReplaceRows	Returns a table where the rows at a specified position are replaced with the given rows.
Table.ReverseRows	Returns a table with rows in reverse order.
Table.HasColumns	Returns true if a table contains all of the specified column names.
Table.PrefixColumns	Returns a table where every column name has been prefixed with a given text value.
Table.ColumnsOfType	Returns a list of column names whose types match any of the specified types.
Table.AddColumn	Returns a table with a new column appended, where each value is computed by a function applied to each row.
Table.DuplicateColumn	Returns a table with a copy of the specified column added under a new name.
Table.FillUp	Returns a table where null values in each column are replaced with the first non-null value above them in that column.
Table.RemoveLastN	Returns a table with the last N rows removed.
Table.RemoveFirstN	Returns a table with the first N rows removed.
Table.ExpandListColumn	Returns a table where a column of lists is expanded so each list element becomes its own row.
Table.ExpandTableColumn	Returns a table where a column of tables or records is expanded into multiple columns.
Table.TransformRows	Returns a table produced by applying a transform function to each row of the original table.
Table.Transpose	Returns a table with columns and rows swapped.
Table.DemoteHeaders	Returns a table where the header row is moved down to become the first data row, and generic column names are assigned.
Table.ToRows	Returns a list of lists, where each inner list contains the values for one row of the table.
Table.ToColumns	Returns a list of lists, where each inner list contains all values for one column of the table.
Table.CombineColumnsToRecord	Returns a table with specified columns combined into a single record-valued column.
Table.Contains	Returns true if the specified record appears as a row in the table.
Table.ContainsAll	Returns true if all of the specified records appear as rows in the table.
Table.ContainsAny	Returns true if any of the specified records appear as rows in the table.
Table.IsDistinct	Returns true if every row in the table is unique (no duplicate rows exist).
Table.PositionOf	Returns the row index of the first occurrence of a given record in a table, or a list of all positions if specified.
Table.PositionOfAny	Returns the row index of the first occurrence of any of the given records in a table.
Table.RemoveMatchingRows	Returns a table with all rows that match any of the specified records removed.
Table.ReplaceMatchingRows	Returns a table where rows matching any of the specified records are replaced with given replacement rows.
Table.Max	Returns the row containing the maximum value for a given column or comparison function, or a default value if the table is empty.
Table.MaxN	Returns the N rows with the largest values for a given column or comparison function.
Table.Min	Returns the row containing the minimum value for a given column or comparison function, or a default value if the table is empty.
Table.MinN	Returns the N rows with the smallest values for a given column or comparison function.
Table.FindText	Returns a table containing only rows where the specified text appears in at least one cell.
Table.ReplaceValue	Returns a table where a specified value is replaced with another value in the given columns.
Table.IsEmpty	Returns true if a table contains no rows.
Table.SplitColumn	Returns a table where a text column is split into multiple columns using a splitter function.
Table.CombineColumns	Returns a table where two or more columns are merged into a single column using a combiner function.
Table.FirstValue	Returns the value of the first cell in the first row of a table, or a default value if the table is empty.
Table.AddRankColumn	Adds a new column to a table containing the rank of each row based on specified criteria.
Table.View	Returns a table with custom handler functions attached for query operations such as filtering, sorting, and row counts.
Table.ViewFunction	Returns a function from a view that can be used when constructing a custom view with Table.View.
Table.ViewError	Creates an error record that, when thrown inside a view handler, prevents a fallback query from running.
Table.Schema	Returns a table describing the columns of a given table, including their names, types, and type metadata.
Table.Profile	Returns a table containing per-column statistics such as min, max, average, and null count for a given table.
Table.FromList	Returns a table by converting a list into rows using a specified splitter function.
Table.ToList	Returns a list by combining each row of a table into a single value using a combiner function.
Table.FromValue	Returns a single-column table containing the provided value or list of values.
Table.ConformToPageReader	Returns a table that conforms to the contract expected by a page reader, for use in custom connector pagination.
Table.Type	Returns the table type of a given table.
Table.ColumnNames	Returns a list of column names for a table, in column order.
Tables.GetRelationships	Returns a list of relationships between a set of tables.
Table.FromColumns	Returns a table built from a list of column names and a corresponding list of value lists.
Table.FromPartitions	Returns a table built by combining a set of partitioned tables into one, optionally adding a column identifying the partition each row came from.
Table.PartitionValues	Returns a table describing each partition’s key values, as defined by Table.PartitionKey.
Table.FromRows	Returns a table built from a list of records, with each record becoming one row.
Table.PromoteHeaders	Returns a table where the first data row is promoted to be the column header row.
Table.RowCount	Returns the number of rows in a table.
Table.ApproximateRowCount	Returns an approximate row count for a table, using metadata hints when available for faster performance against large sources.
Table.ToRecords	Returns a list of records, where each record represents one row of the table.
Table.FromRecords	Returns a table built from a list of records, where each record becomes one row.
Table.Keys	Returns the keys defined on a table.
Table.AddKey	Returns a table with a key added, identifying one or more columns that uniquely identify rows.
Table.ReplaceKeys	Returns a table with all existing keys replaced by the specified set of keys.
Table.PartitionKey	Returns the partition key defined on a table.
Table.ReplacePartitionKey	Returns a table with the partition key replaced by the specified partition key.
Table.Column	Returns the values of a specified column as a list.
Table.SelectColumns	Returns a table containing only the specified columns, in the given order.
Table.SelectRows	Returns a table containing only the rows that satisfy a given condition.
Table.RenameColumns	Returns a table with columns renamed according to a list of old-name, new-name pairs.
Table.TransformColumnNames	Returns a table with column names transformed by applying a function to each name.
Table.ReorderColumns	Returns a table with columns rearranged in the specified order.
Table.Skip	Returns a table with the first N rows removed.
Table.First	Returns the first row of a table as a record, or a default value if the table is empty.
Table.FirstN	Returns the first N rows of a table.
Table.RemoveColumns	Returns a table with the specified columns removed.
Table.Group	Returns a table where rows are grouped by the values of specified columns, with aggregation applied to each group.
Table.Join	Returns a table by joining two tables on matching key columns, using the specified join kind.
Table.AddJoinColumn	Returns a table with a new column added that contains the matching rows from a second table, without flattening the join.
Table.NestedJoin	Joins two tables on matching columns and returns the result of the join as a new record-valued column, without expanding it.
Table.AddIndexColumn	Returns a table with a new column added containing a sequential integer index, starting at a specified value.
Table.FillDown	Returns a table where null values in each column are replaced with the most recent non-null value above them in that column.
Table.TransformColumns	Returns a table where values in specified columns are transformed by applying a function to each value.
Table.TransformColumnTypes	Returns a table with column types changed to the specified types, using an optional culture for parsing.
Table.Sort	Returns a table sorted by one or more columns, each with an optional ascending or descending order.
Table.Distinct	Returns a table with duplicate rows removed, optionally considering only specified columns.
Table.ExpandRecordColumn	Returns a table where a column of records is expanded into multiple columns, one per record field.
Table.AggregateTableColumn	Returns a table where a column of tables is aggregated into multiple columns using specified aggregation functions.
Table.SingleRow	Returns the single row of a table as a record, and raises an error if the table does not contain exactly one row.
Table.Combine	Returns a table that is the concatenation of a list of tables.
Table.Pivot	Returns a table by pivoting a column of distinct values into new columns, aggregating values from another column.
Table.Unpivot	Returns a table by unpivoting specified columns into attribute-value row pairs.
Table.UnpivotOtherColumns	Returns a table by unpivoting all columns except those specified into attribute-value row pairs.
Table.SelectRowsWithErrors	Returns a table containing only rows that have an error in at least one cell in the specified columns.
Table.RemoveRowsWithErrors	Returns a table with rows removed where any cell in the specified columns contains an error.
Table.ReplaceErrorValues	Returns a table where error values in specified columns are replaced with given replacement values.
Table.ReplaceRelationshipIdentity	Returns a table with the relationship identity column replaced, for use in incremental refresh scenarios.
Table.FilterWithDataTable	Filters a table by retaining only rows whose key column values match values in a provided in-memory data table.
Table.Split	Splits a table into a list of tables each containing at most the specified number of rows.
Table.SplitAt	Returns a list of two tables: the first contains rows before the given index, and the second contains rows from that index onward.
Table.Buffer	Returns a table with all data loaded into memory, preventing repeated evaluation of the upstream query.
Table.StopFolding	Returns a table that prevents any further query folding from being applied to it against the original data source.
Table.WithErrorContext	Returns a table where any errors raised during evaluation include additional context information.
Table.AddFuzzyClusterColumn	Adds a new column to a table containing representative cluster values based on fuzzy matching of an existing text column.
Table.FuzzyGroup	Groups rows in a table by fuzzy matching on a specified text column, treating similar values as belonging to the same group.
Table.FuzzyJoin	Joins two tables on a text column using fuzzy matching, so rows with approximately equal values are treated as matches.
Table.FuzzyNestedJoin	Performs a fuzzy join between two tables on a text column and returns the matching rows as a nested table column without expanding them.

Text functions

Power Query Function Name	Description
Text.AfterDelimiter	Returns the portion of a text string that appears after a specified delimiter.
Text.BeforeDelimiter	Returns the portion of a text string that appears before a specified delimiter.
Text.BetweenDelimiters	Returns the portion of a text string found between two specified delimiters.
Character.Type	Returns the type value for a single-character text value.
Character.FromNumber	Converts a numeric code point to its corresponding single character.
Character.ToNumber	Returns the numeric code point of a single character.
Text.Type	Returns the type value representing the text type in M.
Text.At	Returns the character at a specified zero-based position in a text string.
Text.From	Converts a value of any type to its text representation.
Text.Length	Returns the number of characters in a text string.
Text.Range	Returns a substring starting at a given position for a given number of characters.
Text.Middle	Returns a substring from a text string, starting at a specified position for a given length.
Text.Start	Returns the specified number of characters from the beginning of a text string.
Text.End	Returns the specified number of characters from the end of a text string.
Text.StartsWith	Returns true if a text string begins with a specified substring.
Text.EndsWith	Returns true if a text string ends with a specified substring.
Text.Contains	Returns true if a specified substring is found anywhere within a text string.
Text.Clean	Removes all non-printable characters from a text string.
Text.PositionOf	Returns the zero-based position of the first (or specified) occurrence of a substring within a text string.
Text.PositionOfAny	Returns the zero-based position of the first character in a text string that matches any character in a given list.
Text.Lower	Converts all characters in a text string to lowercase.
Text.Upper	Converts all characters in a text string to uppercase.
Text.Proper	Converts a text string to title case, capitalizing the first letter of each word.
Text.Split	Splits a text string into a list of substrings using a specified delimiter.
Text.SplitAny	Splits a text string into a list of substrings at any character that appears in a specified set of delimiters.
Text.Combine	Joins a list of text strings into a single string, optionally separated by a delimiter.
Text.Repeat	Returns a new text string formed by repeating the given text a specified number of times.
Text.Replace	Replaces all occurrences of a substring within a text string with a new substring.
Text.ReplaceRange	Removes a range of characters from a text string and inserts replacement text at that position.
Text.Insert	Inserts a text string into another text string at a specified position.
Text.Remove	Removes all occurrences of characters in a given list from a text string.
Text.RemoveRange	Removes a specified number of characters from a text string starting at a given position.
Text.Reverse	Returns a new text string with the characters in reverse order.
Text.Select	Returns only the characters from a text string that appear in a specified list of allowed characters.
Text.Trim	Removes leading and trailing whitespace (or specified characters) from a text string.
Text.TrimStart	Removes leading whitespace or specified characters from the beginning of a text string.
Text.TrimEnd	Removes trailing whitespace or specified characters from the end of a text string.
Text.PadStart	Pads a text string on the left with a specified character until it reaches a given length.
Text.PadEnd	Pads a text string on the right with a specified character until it reaches a given length.
Text.ToBinary	Encodes a text string to a binary value using a specified encoding.
Text.ToList	Converts a text string into a list where each element is one character.
Text.FromBinary	Decodes a binary value into a text string using a specified encoding.
Text.NewGuid	Returns a new randomly generated GUID as a text string.
Text.InferNumberType	Infers and returns the most specific numeric type (Int64, Double, etc.) that can represent a given text value.
Text.Format	Returns a formatted text string by substituting values into a template that uses positional placeholders.

Number functions

Power Query Function Name	Description
Number.E	Returns the mathematical constant e (approximately 2.71828), the base of natural logarithms.
Number.PI	Returns the mathematical constant pi (approximately 3.14159), the ratio of a circle’s circumference to its diameter.
Number.Type	Represents the number data type in Power Query M.
Number.From	Converts a value to a number.
Number.FromText	Converts a text string to a number.
Number.ToText	Converts a number to a text string, with optional format and culture arguments.
Number.IsNaN	Returns true if the given value is NaN (not a number), false otherwise.
Number.NaN	Returns the special Not-a-Number (NaN) value.
Number.NegativeInfinity	Returns the value representing negative infinity.
Number.PositiveInfinity	Returns the value representing positive infinity.
Number.Epsilon	Returns the smallest positive number representable in the M numeric type.
Number.BitwiseNot	Returns the bitwise NOT (complement) of an integer value.
Number.BitwiseOr	Returns the bitwise OR of two integer values.
Number.BitwiseAnd	Returns the bitwise AND of two integer values.
Number.BitwiseXor	Returns the bitwise XOR of two integer values.
Number.BitwiseShiftLeft	Shifts the bits of an integer left by a specified number of positions.
Number.BitwiseShiftRight	Shifts the bits of an integer right by a specified number of positions.
Number.Abs	Returns the absolute value of a number.
Number.Acos	Returns the arccosine (inverse cosine) of a number, in radians.
Number.Asin	Returns the arcsine (inverse sine) of a number, in radians.
Number.Atan	Returns the arctangent (inverse tangent) of a number, in radians.
Number.Atan2	Returns the arctangent of the quotient of two numbers (y/x), in radians.
Number.Combinations	Returns the number of combinations for a given number of items from a set.
Number.Cos	Returns the cosine of an angle given in radians.
Number.Cosh	Returns the hyperbolic cosine of a number.
Number.Exp	Returns e raised to the power of the given number.
Number.Factorial	Returns the factorial of a non-negative integer.
Number.IntegerDivide	Divides two numbers and returns the integer part of the result.
Number.Log	Returns the logarithm of a number to a specified base (defaults to e).
Number.Log10	Returns the base-10 logarithm of a number.
Number.Ln	Returns the natural logarithm (base e) of a number.
Number.Mod	Returns the remainder after dividing one number by another.
Number.Permutations	Returns the number of permutations for a given number of items from a set.
Number.Power	Returns a number raised to the specified power.
Number.Random	Returns a random number between 0 and 1.
Number.RandomBetween	Returns a random number between the specified lower and upper bounds.
Number.Round	Rounds a number to the specified number of decimal places, with optional rounding mode control.
Number.RoundDown	Rounds a number down (toward negative infinity) to the specified number of decimal places.
Number.RoundUp	Rounds a number up (toward positive infinity) to the specified number of decimal places.
Number.RoundTowardZero	Rounds a number toward zero to the specified number of decimal places.
Number.RoundAwayFromZero	Rounds a number away from zero to the specified number of decimal places.
Number.Sign	Returns 1 for positive numbers, -1 for negative numbers, and 0 for zero.
Number.Sin	Returns the sine of an angle given in radians.
Number.Sinh	Returns the hyperbolic sine of a number.
Number.Sqrt	Returns the square root of a number.
Number.Tan	Returns the tangent of an angle given in radians.
Number.Tanh	Returns the hyperbolic tangent of a number.
Number.IsEven	Returns true if a number is even, false otherwise.
Number.IsOdd	Returns true if a number is odd, false otherwise.

Date functions

Power Query Function Name	Description
Date.IsInPreviousDay	Returns true if the given date falls within the previous calendar day relative to the current date.
Date.IsInPreviousNDays	Returns true if the given date falls within the previous N days relative to today.
Date.IsInCurrentDay	Returns true if the given date is today.
Date.IsInNextDay	Returns true if the given date falls within the next calendar day relative to the current date.
Date.IsInNextNDays	Returns true if the given date falls within the next N days relative to today.
Date.IsInPreviousWeek	Returns true if the given date falls within the previous calendar week.
Date.IsInPreviousNWeeks	Returns true if the given date falls within the previous N calendar weeks relative to the current week.
Date.IsInCurrentWeek	Returns true if the given date falls within the current calendar week.
Date.IsInNextWeek	Returns true if the given date falls within the next calendar week.
Date.IsInNextNWeeks	Returns true if the given date falls within the next N calendar weeks relative to the current week.
Date.IsInPreviousMonth	Returns true if the given date falls within the previous calendar month.
Date.IsInPreviousNMonths	Returns true if the given date falls within the previous N calendar months relative to the current month.
Date.IsInCurrentMonth	Returns true if the given date falls within the current calendar month.
Date.IsInNextMonth	Returns true if the given date falls within the next calendar month.
Date.IsInNextNMonths	Returns true if the given date falls within the next N calendar months relative to the current month.
Date.IsInPreviousQuarter	Returns true if the given date falls within the previous calendar quarter.
Date.IsInPreviousNQuarters	Returns true if the given date falls within the previous N calendar quarters relative to the current quarter.
Date.IsInCurrentQuarter	Returns true if the given date falls within the current calendar quarter.
Date.IsInNextQuarter	Returns true if the given date falls within the next calendar quarter.
Date.IsInNextNQuarters	Returns true if the given date falls within the next N calendar quarters relative to the current quarter.
Date.IsInPreviousYear	Returns true if the given date falls within the previous calendar year.
Date.IsInPreviousNYears	Returns true if the given date falls within the previous N calendar years relative to the current year.
Date.IsInCurrentYear	Returns true if the given date falls within the current calendar year.
Date.IsInNextYear	Returns true if the given date falls within the next calendar year.
Date.IsInNextNYears	Returns true if the given date falls within the next N calendar years relative to the current year.
Date.IsInYearToDate	Returns true if the given date falls between January 1 of the current year and today, inclusive.
Date.MonthName	Returns the name of the month component of a date value as text.
Date.DayOfWeekName	Returns the name of the weekday for the given date as text.
Date.FromText	Creates a date value from a text representation using an optional culture.
Date.From	Returns a date value from the given value, converting numbers, text, or datetime values as needed.
Date.ToText	Returns a text representation of the given date value, with optional format and culture.
Date.ToRecord	Returns a record with the year, month, and day components of the given date.
Date.Year	Returns the year component of a date value as a number.
Date.Month	Returns the month component of a date value as a number (1 through 12).
Date.Day	Returns the day component of a date value as a number.
Date.AddDays	Returns a new date by adding the specified number of days to the given date.
Date.AddWeeks	Returns a new date by adding the specified number of weeks to the given date.
Date.AddMonths	Returns a new date by adding the specified number of months to the given date.
Date.AddQuarters	Returns a new date by adding the specified number of quarters to the given date.
Date.AddYears	Returns a new date by adding the specified number of years to the given date.
Date.IsLeapYear	Returns true if the year of the given date is a leap year.
Date.StartOfYear	Returns the first day of the year for the given date (January 1).
Date.StartOfQuarter	Returns the first day of the quarter that contains the given date.
Date.StartOfMonth	Returns the first day of the month for the given date.
Date.StartOfWeek	Returns the first day of the week that contains the given date, with optional first-day-of-week setting.
Date.StartOfDay	Returns the start of the day for the given date value.
Date.EndOfYear	Returns the last day of the year for the given date (December 31).
Date.EndOfQuarter	Returns the last day of the quarter that contains the given date.
Date.EndOfMonth	Returns the last day of the month for the given date.
Date.EndOfWeek	Returns the last day of the week that contains the given date, with optional first-day-of-week setting.
Date.EndOfDay	Returns the end of the day for the given date value.
Date.DayOfWeek	Returns the day of the week for the given date as a number (0 through 6), with optional first-day-of-week setting.
Date.DayOfYear	Returns the day of the year for the given date as a number (1 through 366).
Date.DaysInMonth	Returns the number of days in the month for the given date.
Date.QuarterOfYear	Returns the quarter of the year for the given date as a number (1 through 4).
Date.WeekOfMonth	Returns the week number within the month for the given date.
Date.WeekOfYear	Returns the week number within the year for the given date.
Date.Type	Returns the type value for the date type.

DateTime functions

Power Query Function Name	Description
DateTime.IsInPreviousSecond	Returns true if the given datetime falls within the previous second relative to now.
DateTime.IsInPreviousNSeconds	Returns true if the given datetime falls within the previous N seconds relative to now.
DateTime.IsInNextSecond	Returns true if the given datetime falls within the next second relative to now.
DateTime.IsInNextNSeconds	Returns true if the given datetime falls within the next N seconds relative to now.
DateTime.IsInCurrentSecond	Returns true if the given datetime falls within the current second.
DateTime.IsInPreviousMinute	Returns true if the given datetime falls within the previous minute relative to now.
DateTime.IsInPreviousNMinutes	Returns true if the given datetime falls within the previous N minutes relative to now.
DateTime.IsInNextMinute	Returns true if the given datetime falls within the next minute relative to now.
DateTime.IsInNextNMinutes	Returns true if the given datetime falls within the next N minutes relative to now.
DateTime.IsInCurrentMinute	Returns true if the given datetime falls within the current minute.
DateTime.IsInPreviousHour	Returns true if the given datetime falls within the previous hour relative to now.
DateTime.IsInPreviousNHours	Returns true if the given datetime falls within the previous N hours relative to now.
DateTime.IsInNextHour	Returns true if the given datetime falls within the next hour relative to now.
DateTime.IsInNextNHours	Returns true if the given datetime falls within the next N hours relative to now.
DateTime.IsInCurrentHour	Returns true if the given datetime falls within the current hour.
DateTime.FromText	Creates a datetime value from a text representation using an optional culture.
DateTime.From	Returns a datetime value from the given value, converting dates, times, numbers, or text as needed.
DateTime.ToText	Returns a text representation of the given datetime value, with optional format and culture.
DateTime.ToRecord	Returns a record with the year, month, day, hour, minute, and second components of the given datetime.
DateTime.Date	Returns the date component of a datetime value.
DateTime.Time	Returns the time component of a datetime value.
DateTime.AddZone	Adds timezone offset information to a datetime value, producing a datetimezone value.
DateTime.LocalNow	Returns the current local date and time as a datetime value.
DateTime.FixedLocalNow	Returns a fixed current local datetime that stays constant throughout the evaluation of a query.
DateTime.FromFileTime	Returns a datetime from a Windows file time (a 64-bit integer counting 100-nanosecond intervals since January 1, 1601).
DateTime.Type	Returns the type value for the datetime type.

DateTimeZone functions

Power Query Function Name	Description
DateTimeZone.FromText	Creates a datetimezone value from a text representation using an optional culture.
DateTimeZone.From	Returns a datetimezone value from the given value, converting dates, datetimes, numbers, or text as needed.
DateTimeZone.ToText	Returns a text representation of the given datetimezone value, with optional format and culture.
DateTimeZone.ToRecord	Returns a record with the year, month, day, hour, minute, second, zone hours, and zone minutes components of the given datetimezone.
DateTimeZone.ZoneHours	Returns the timezone offset hours component of a datetimezone value.
DateTimeZone.ZoneMinutes	Returns the timezone offset minutes component of a datetimezone value.
DateTimeZone.LocalNow	Returns the current local date, time, and timezone offset as a datetimezone value.
DateTimeZone.UtcNow	Returns the current date, time, and UTC offset as a datetimezone value.
DateTimeZone.FixedLocalNow	Returns a fixed current local datetimezone that stays constant throughout the evaluation of a query.
DateTimeZone.FixedUtcNow	Returns a fixed current UTC datetimezone that stays constant throughout the evaluation of a query.
DateTimeZone.ToLocal	Converts a datetimezone value to the local timezone.
DateTimeZone.ToUtc	Converts a datetimezone value to UTC.
DateTimeZone.SwitchZone	Changes the timezone offset of a datetimezone value to the specified hours and optional minutes offset.
DateTimeZone.RemoveZone	Removes the timezone offset from a datetimezone value, returning a datetime.
DateTimeZone.FromFileTime	Returns a datetimezone from a Windows file time (a 64-bit integer counting 100-nanosecond intervals since January 1, 1601).
DateTimeZone.Type	Returns the type value for the datetimezone type.

Time functions

Power Query Function Name	Description
Time.FromText	Creates a time value from a text representation using an optional culture.
Time.From	Returns a time value from the given value, converting datetimes, numbers, or text as needed.
Time.ToText	Returns a text representation of the given time value, with optional format and culture.
Time.ToRecord	Returns a record with the hour, minute, and second components of the given time value.
Time.Hour	Returns the hour component of a time value as a number (0 through 23).
Time.Minute	Returns the minute component of a time value as a number (0 through 59).
Time.Second	Returns the second component of a time value as a number (0 through 59).
Time.StartOfHour	Returns the start of the hour (minutes and seconds set to zero) for the given time value.
Time.EndOfHour	Returns the last moment of the hour (59 minutes, 59.9999999 seconds) for the given time value.
Time.Type	Returns the type value for the time type.

Duration functions

Power Query Function Name	Description
Duration.Type	Returns the type value for the duration type.
Duration.FromText	Creates a duration value from a text representation in ISO 8601 duration format.
Duration.From	Returns a duration value from the given value, converting numbers or text as needed.
Duration.ToText	Returns a text representation of the given duration value in ISO 8601 format.
Duration.ToRecord	Returns a record with the days, hours, minutes, and seconds components of the given duration.
Duration.Days	Returns the days component of a duration value.
Duration.Hours	Returns the hours component of a duration value.
Duration.Minutes	Returns the minutes component of a duration value.
Duration.Seconds	Returns the seconds component of a duration value.
Duration.TotalDays	Returns the total number of days represented by a duration value, including fractional days.
Duration.TotalHours	Returns the total number of hours represented by a duration value, including fractional hours.
Duration.TotalMinutes	Returns the total number of minutes represented by a duration value, including fractional minutes.
Duration.TotalSeconds	Returns the total number of seconds represented by a duration value, including fractional seconds.

Record functions

Power Query Function Name	Description
Record.Type	Returns the type of a record value.
Record.AddField	Adds a new field to a record with a given name and value.
Record.Field	Returns the value of a named field from a record.
Record.FieldCount	Returns the number of fields in a record.
Record.FieldNames	Returns a list of the field names in a record, in definition order.
Record.FieldOrDefault	Returns the value of a named field from a record, or a default value if the field does not exist.
Record.FieldValues	Returns a list of the field values in a record, in definition order.
Record.FromTable	Converts a two-column table of name-value pairs into a record.
Record.HasFields	Returns true if the record contains all of the specified field names.
Record.RemoveFields	Returns a new record with one or more named fields removed.
Record.RenameFields	Returns a new record with fields renamed according to a list of old-name/new-name pairs.
Record.ReorderFields	Returns a new record with fields reordered to match a given list of field names.
Record.SelectFields	Returns a new record containing only the specified fields.
Record.ToTable	Converts a record into a two-column table with Name and Value columns.
Record.TransformFields	Returns a new record with field values transformed by applying functions specified in a transformation list.
Record.Combine	Merges a list of records into a single record; later records take precedence on duplicate field names.
Record.FromList	Creates a record from a list of values and a matching list of field names.
Record.ToList	Returns a list of the field values in a record, in definition order.

Value functions

Power Query Function Name	Description
Value.ResourceExpression	Returns the resource expression associated with a value, used to identify the data source.
Value.Equals	Returns true if two values are equal, with optional comparison culture or criteria.
Value.NullableEquals	Compares two nullable values for equality, treating null as a valid equal value when both sides are null.
Value.Compare	Compares two values and returns -1, 0, or 1 to indicate less than, equal, or greater than.
Value.Type	Returns the type of a value.
Value.ReplaceType	Returns a copy of a value with its type replaced by the specified type.
Value.RemoveMetadata	Returns a copy of a value with all metadata removed.
Value.ReplaceMetadata	Returns a copy of a value with its metadata replaced by the provided metadata record.
Value.Metadata	Returns the metadata record associated with a value, or an empty record if there is none.
Value.FromText	Parses a text value into a typed value based on the specified type.
Value.Add	Returns the result of adding two values, equivalent to the + operator.
Value.Subtract	Returns the result of subtracting one value from another, equivalent to the – operator.
Value.Multiply	Returns the result of multiplying two values, equivalent to the * operator.
Value.Divide	Returns the result of dividing one value by another, equivalent to the / operator.
Value.As	Asserts that a value is compatible with a specified type and returns it, or raises an error if not.
Value.Is	Returns true if a value is compatible with the specified type.
Value.NativeQuery	Executes a native query against a data source, passing it through as-is to the underlying provider.
Value.Expression	Returns an abstract syntax tree expression that represents a value.
Value.Optimize	Returns an optimized version of a value where any pending evaluations are resolved.
Value.Alternates	Returns a list of alternate representations or sources for a value.
Value.Versions	Returns a record of versioned variants of a value, keyed by version identifier.
Value.VersionIdentity	Returns the version identity of a value, identifying which version it represents.
Value.ViewFunction	Returns a named function from a view value created with Table.View or a similar mechanism.
Value.ViewError	Creates an error record used to signal a failure within a view handler.
Value.Firewall	Wraps a value with firewall partition semantics to enforce data-source isolation rules.
Value.Lineage	Returns lineage metadata describing the origin of a value within the query engine.
Value.Traits	Returns the traits record associated with a value, describing behavioral hints for the engine.

Type functions

Power Query Function Name	Description
Type.TableSchema	Returns a table describing the columns, types, and constraints of a table type.
Type.Type	Represents the type data type in Power Query M.
Type.ForRecord	Constructs a record type from a record describing its fields and their types.
Type.ForFunction	Constructs a function type from a record describing its parameter types and return type.
Type.NonNullable	Returns a version of the given type that does not allow null values.
Type.IsNullable	Returns true if the given type allows null values, false otherwise.
Type.ListItem	Returns the item type of a list type.
Type.OpenRecord	Returns an open record type, which allows fields beyond those explicitly defined.
Type.ClosedRecord	Returns a closed version of a record type, which disallows extra fields.
Type.IsOpenRecord	Returns true if the given type is an open record type, false otherwise.
Type.RecordFields	Returns a record describing the fields of a record type, including each field’s type and optionality.
Type.FunctionParameters	Returns a record describing the parameters of a function type.
Type.FunctionRequiredParameters	Returns the number of required parameters for a function type.
Type.FunctionReturn	Returns the return type of a function type.
Type.Is	Returns true if a value of the first type is always compatible with the second type.
Type.Union	Returns the union of a list of types.
Type.Facets	Returns the facets (constraints such as precision or scale) of a type.
Type.ReplaceFacets	Returns a new type with the facets replaced by those in the provided record.
Type.TableColumn	Returns the type of a specified column in a table type.
Type.TableRow	Returns the row type of a table type.
Type.TableKeys	Returns the keys defined on a table type.
Type.AddTableKey	Returns a new table type with an additional key added.
Type.ReplaceTableKeys	Returns a new table type with the keys replaced by the provided list.
Type.TablePartitionKey	Returns the partition key of a table type.
Type.ReplaceTablePartitionKey	Returns a new table type with the partition key replaced.

Type and conversion functions

Power Query Function Name	Description
Any.Type	Represents the any data type, which accepts all values.
None.Type	Represents the none data type, a type that no value belongs to.
Byte.Type	Represents the 8-bit unsigned integer data type.
Null.Type	Represents the null data type.
Int8.Type	Represents the 8-bit signed integer data type.
Int16.Type	Represents the 16-bit signed integer data type.
Int32.Type	Represents the 32-bit signed integer data type.
Int64.Type	Represents the 64-bit signed integer data type.
Single.Type	Represents the single-precision floating-point data type.
Double.Type	Represents the double-precision floating-point data type.
Decimal.Type	Represents the decimal number data type.
Currency.Type	Represents the currency (fixed decimal) data type.
Percentage.Type	Represents the percentage data type.
Guid.Type	Represents the GUID data type.
Password.Type	Represents the password (masked text) data type.
Certificate.Type	Represents the certificate data type.
Byte.From	Converts a value to an 8-bit unsigned integer.
Int8.From	Converts a value to an 8-bit signed integer.
Int16.From	Converts a value to a 16-bit signed integer.
Int32.From	Converts a value to a 32-bit signed integer.
Int64.From	Converts a value to a 64-bit signed integer.
Single.From	Converts a value to a single-precision floating-point number.
Double.From	Converts a value to a double-precision floating-point number.
Decimal.From	Converts a value to a decimal number.
Currency.From	Converts a value to a currency (fixed decimal) value.
Percentage.From	Converts a value to a percentage value.
Guid.From	Converts a value to a GUID.

Logical functions

Power Query Function Name	Description
Logical.Type	Represents the logical (true/false) data type.
Logical.FromText	Converts a text string (“true” or “false”) to a logical value.
Logical.From	Converts a value to a logical (true/false) value.
Logical.ToText	Converts a logical value to its text representation (“true” or “false”).

Binary functions

Power Query Function Name	Description
Binary.View	Creates a custom view of a binary value with user-defined handlers for operations like read and length.
Binary.ViewFunction	Returns a function from a binary view that was created with Binary.View.
Binary.ViewError	Creates an error record used to signal a failure within a binary view handler.
Binary.ApproximateLength	Returns the approximate length of a binary value, or -1 if the length is unknown.
Binary.Type	Returns the type of a binary value.
Binary.ToText	Encodes a binary value as a Base64 text string.
Binary.From	Returns a binary value from a given value, converting it if necessary.
Binary.FromText	Decodes a Base64-encoded text string into a binary value.
Binary.ToList	Converts a binary value into a list of byte values.
Binary.FromList	Converts a list of byte values into a binary value.
Binary.Combine	Concatenates a list of binary values into a single binary value.
Binary.Length	Returns the number of bytes in a binary value.
Binary.Buffer	Buffers a binary value in memory, reading it once so subsequent accesses are fast.
Binary.Compress	Compresses a binary value using the specified compression algorithm.
Binary.Decompress	Decompresses a binary value using the specified compression algorithm.
Binary.InferContentType	Inspects a binary value and returns a record with an inferred content-type field.
Binary.Range	Returns a subset of a binary value starting at a given byte offset, with an optional length.
Binary.Split	Splits a binary value into a list of binary values at each occurrence of a separator.
BinaryFormat.SignedInteger16	A binary format that reads a signed 16-bit integer.
BinaryFormat.SignedInteger32	A binary format that reads a signed 32-bit integer.
BinaryFormat.SignedInteger64	A binary format that reads a signed 64-bit integer.
BinaryFormat.UnsignedInteger16	A binary format that reads an unsigned 16-bit integer.
BinaryFormat.UnsignedInteger32	A binary format that reads an unsigned 32-bit integer.
BinaryFormat.UnsignedInteger64	A binary format that reads an unsigned 64-bit integer.
BinaryFormat.Single	A binary format that reads a 32-bit IEEE single-precision floating-point number.
BinaryFormat.Double	A binary format that reads a 64-bit IEEE double-precision floating-point number.
BinaryFormat.Decimal	A binary format that reads a 96-bit .NET decimal number.
BinaryFormat.7BitEncodedUnsignedInteger	A binary format that reads a variable-length 7-bit encoded unsigned integer.
BinaryFormat.7BitEncodedSignedInteger	A binary format that reads a variable-length 7-bit encoded signed integer.
BinaryFormat.Byte	A binary format that reads a single unsigned byte.
BinaryFormat.Binary	A binary format that reads a length-prefixed binary value.
BinaryFormat.Record	A binary format that reads a record by applying a separate binary format to each named field.
BinaryFormat.List	A binary format that reads a sequence of items using a given item format and returns them as a list.
BinaryFormat.Text	A binary format that reads a length-prefixed text value.
BinaryFormat.Transform	Creates a binary format that transforms the value read by another binary format using a provided function.
BinaryFormat.Length	Creates a binary format that reads a fixed number of bytes and applies another format to the result.
BinaryFormat.Choice	Creates a binary format that chooses which format to use next based on a value already read.
BinaryFormat.ByteOrder	Creates a binary format with a specific byte order (endianness) applied to another format.
BinaryFormat.Group	Reads a group of items from binary data using a key format, item format, and optional parameters.
BinaryFormat.Null	A binary format that reads zero bytes and returns null.

Splitter functions

Power Query Function Name	Description
Splitter.SplitByNothing	Returns a function that does not split the input text, returning it as a single-element list.
Splitter.SplitTextByCharacterTransition	Returns a function that splits text at boundaries where the character category changes, such as from letters to digits.
Splitter.SplitTextByDelimiter	Returns a function that splits text by a specified delimiter, with control over which occurrence to split on.
Splitter.SplitTextByRanges	Returns a function that splits text into substrings according to a list of offset-and-length pairs.
Splitter.SplitTextByWhitespace	Returns a function that splits text on any whitespace characters.
Splitter.SplitTextByEachDelimiter	Returns a function that splits text by each delimiter in a list, one at a time in sequence.
Splitter.SplitTextByAnyDelimiter	Returns a function that splits text at any occurrence of any delimiter in a given list.
Splitter.SplitTextByPositions	Returns a function that splits text at specific character positions.
Splitter.SplitTextByRepeatedLengths	Returns a function that splits text into substrings of a fixed repeated length.
Splitter.SplitTextByLengths	Returns a function that splits text into substrings according to a list of specified lengths.

Combiner functions

Power Query Function Name	Description
Combiner.CombineTextByDelimiter	Returns a function that combines a list of text values into a single string using a specified delimiter.
Combiner.CombineTextByEachDelimiter	Returns a function that combines text values by inserting each delimiter in a list between successive items.
Combiner.CombineTextByRanges	Returns a function that combines text by placing each value into a fixed-width field defined by offset-and-length pairs.
Combiner.CombineTextByPositions	Returns a function that combines text by placing each value starting at specified character positions.
Combiner.CombineTextByLengths	Returns a function that combines text by padding or truncating each value to a specified length.

Comparer functions

Power Query Function Name	Description
Comparer.FromCulture	Returns a comparer function that compares text values according to the rules of a specified culture and optional case sensitivity.
Comparer.Ordinal	Returns a comparer function that compares text values using strict ordinal (byte-by-byte) comparison.
Comparer.OrdinalIgnoreCase	Returns a comparer function that performs ordinal text comparison while ignoring differences in letter case.
Comparer.Equals	Returns a comparer function that tests two values for equality using a specified base comparer.

Replacer functions

Power Query Function Name	Description
Replacer.ReplaceValue	A replacer function that replaces an exact value match with a new value, used in operations like Table.ReplaceValue.
Replacer.ReplaceText	A replacer function that replaces occurrences of a text substring with a new text value, used in operations like Table.ReplaceValue.

Expression functions

Power Query Function Name	Description
Expression.Constant	Returns an M abstract syntax tree (AST) node representing a constant value.
Expression.Evaluate	Evaluates a text string as an M expression and returns the result, optionally within a given environment.
Expression.Identifier	Returns an M AST node representing an identifier with the given name.
RowExpression.From	Returns the AST of the function body for a single-argument function used in a row expression context.
RowExpression.Row	Returns an AST node representing the current row in a row expression context.
RowExpression.Column	Returns an AST node representing access to a named column in the current row within a row expression.
ItemExpression.From	Returns the AST of the function body for a single-argument function used in an item expression context.
ItemExpression.Item	Returns an AST node representing the current item in an item expression context.

Function values

Power Query Function Name	Description
Function.Type	Returns the M type that represents a given function value’s signature.
Function.From	Creates a function value from a given function type and an implementation function.
Function.Invoke	Calls a function with a list of arguments and returns its result.
Function.InvokeAfter	Calls a function after a specified action completes, useful for sequencing side effects.
Function.IsDataSource	Returns true if the given function value is marked as a data source connector.
Function.ScalarVector	Wraps a scalar function so it can be called with a vector (list) of argument lists, returning a list of results.
Function.InvokeWithErrorContext	Invokes a function and attaches additional error context information if the call raises an error.

Lines functions

Power Query Function Name	Description
Lines.FromText	Splits a text value into a list of lines, breaking on line-ending characters.
Lines.FromBinary	Decodes a binary value and splits it into a list of text lines using the specified encoding.
Lines.ToText	Joins a list of text lines into a single text value, inserting line separators between them.
Lines.ToBinary	Joins a list of text lines into a binary value using the specified encoding and line separator.

Uri functions

Power Query Function Name	Description
Uri.Type	Returns the M abstract type that represents a URI value.
Uri.Combine	Combines a base URI and a relative URI string into a single resolved URI.
Uri.Parts	Parses a URI into a record with fields for scheme, host, path, query, and fragment.
Uri.BuildQueryString	Encodes a record or list of name-value pairs into a URL query string.
Uri.EscapeDataString	Percent-encodes a text value so it is safe to use as a URI data component.

Error handling

Power Query Function Name	Description
Error.Record	Creates an error record with the given reason, message, and optional detail fields.
Diagnostics.Trace	Emits a trace message at the specified level and returns a value, useful for lightweight logging during query development.
Diagnostics.ActivityId	Returns a unique identifier for the current query activity, used to correlate diagnostic traces.
Diagnostics.CorrelationId	Returns a correlation identifier that links related activities across a distributed query execution.
Action.WithErrorContext	Wraps an action so that any error it raises is annotated with additional context information.

Cube functions

Power Query Function Name	Description
Cube.DisplayFolders	Returns a table describing the display folder hierarchy for dimensions and measures in a cube.
Cube.Dimensions	Returns a table listing all dimensions available in a cube or multidimensional data source.
Cube.Measures	Returns a table listing all measures available in a cube.
Cube.ReplaceDimensions	Returns a modified cube query with the specified set of dimensions replaced.
Cube.Transform	Applies a series of cube operations to a cube query and returns the transformed result.
Cube.AddMeasureColumn	Adds a column to a table by evaluating a cube measure for each row.
Cube.AddAndExpandDimensionColumn	Adds a dimension to a cube query and expands it into separate columns in the result table.
Cube.CollapseAndRemoveColumns	Collapses expanded dimension columns back into a cube dimension and removes those columns from the table.
Cube.AttributeMemberId	Returns the unique member ID for a given attribute value within a cube dimension.
Cube.AttributeMemberProperty	Returns the value of a named property for an attribute member in a cube dimension.
Cube.PropertyKey	Returns the property key record used to look up a named dimension attribute property.
Cube.MeasureProperty	Returns the value of a named property for a cube measure.
Cube.Properties	Returns a record of standard and custom properties for a cube dimension attribute.
Cube.MeasureProperties	Returns a record of standard and custom properties for a cube measure.
Cube.Parameters	Returns a table of parameters defined for the current cube data source connection.
Cube.ApplyParameter	Applies a parameter value to a cube query and returns the updated query.

Data and content functions

Power Query Function Name	Description
Graph.Nodes	Constructs a table of graph nodes from a seed table and an expansion function, traversing linked records.
Json.Document	Parses a JSON binary or text value and returns the corresponding M value (record, list, or scalar).
Json.FromValue	Serializes an M value to its JSON text representation.
Csv.Document	Parses a CSV binary or text value into a table, with options for delimiter, encoding, and column types.
Embedded.Value	Retrieves a value that was embedded at query-fold time and returns it as an M value.
RData.FromBinary	Parses an R .RData or .rds binary value and returns its contents as an M value.
Xml.Document	Parses an XML binary or text value and returns a record representing the document.
Xml.Tables	Parses an XML binary or text value and returns a table structure inferred from the element hierarchy.
Html.Table	Extracts data from an HTML table element using CSS column selectors and returns the result as an M table.
Pdf.Tables	Extracts tables from a PDF binary value and returns them as a list of table values.

Accessing data functions

Power Query Function Name	Description
Resource.Access	Returns a resource from the given URI with optional access options, used internally by connectors to retrieve secured data sources.
CommonDataService.Database	Connects to a Microsoft Common Data Service (Dataverse) environment and returns a table of available entities.
Kusto.Contents	Connects to an Azure Data Explorer (Kusto) cluster and returns the contents of a specified database.
Kusto.Databases	Returns a table of databases available on the given Azure Data Explorer (Kusto) cluster.
AzureDataExplorer.Contents	Connects to an Azure Data Explorer cluster and returns the contents of a specified database.
AzureDataExplorer.Databases	Returns a table of databases available on the given Azure Data Explorer cluster.
AzureDataExplorer.KqlDatabase	Connects to a KQL database within an Azure Data Explorer cluster and returns its tables and functions.
PowerPlatform.Dataflows	Returns a table of dataflows from the specified Microsoft Power Platform environment.
DataLake.Contents	Connects to an Azure Data Lake Storage account and returns a table of files and folders in the specified path.
DataLake.Files	Returns a table of files from the given Azure Data Lake Storage URL, including content and metadata columns.
Fabric.Warehouse	Connects to a Microsoft Fabric warehouse and returns a table of available schemas and tables.
Lakehouse.Contents	Connects to a Microsoft Fabric Lakehouse and returns a table of available tables and files.
SqlExpression.SchemaFrom	Extracts a schema record from a SQL expression, describing the column names and types the expression would return.
DirectQueryCapabilities.From	Returns a record describing the DirectQuery capabilities supported by a given data source.
Excel.Workbook	Returns a table of sheets, named ranges, and tables found in an Excel workbook binary.
Excel.ShapeTable	Returns a table of shapes contained in an Excel workbook binary.
Module.Versions	Returns a table of installed module names and their version numbers.
SqlExpression.ToExpression	Converts a Power Query expression into an equivalent SQL expression string.
Variable.Value	Returns the value of a named variable from the current evaluation context.
Variable.ValueOrDefault	Returns the value of a named variable from the current evaluation context, or a default value if the variable is not found.
Access.Database	Connects to a Microsoft Access database file and returns a table of available tables and queries.
ActiveDirectory.Domains	Returns a table of domains in the specified Active Directory forest.
AdobeAnalytics.Cubes	Connects to Adobe Analytics and returns a table of available report suites.
AdoDotNet.Query	Executes a query against a .NET ADO data source using the specified provider and connection string, and returns the results as a table.
AdoDotNet.DataSource	Connects to a .NET ADO data source using the given provider and connection string, and returns a table of available tables.
AnalysisServices.Databases	Returns a table of databases available on the specified SQL Server Analysis Services server.
AnalysisServices.Database	Connects to a SQL Server Analysis Services database and returns a table of its cubes and perspectives.
AzureStorage.Blobs	Connects to an Azure Blob Storage account and returns a table of containers.
AzureStorage.BlobContents	Returns the binary contents of a single blob from Azure Blob Storage.
AzureStorage.DataLake	Connects to Azure Data Lake Storage Gen2 and returns a table of files and folders at the specified path.
AzureStorage.DataLakeContents	Returns the binary contents of a single file from Azure Data Lake Storage Gen2.
AzureStorage.Tables	Connects to an Azure Table Storage account and returns a table of available storage tables.
Informix.Database	Connects to an IBM Informix database and returns a table of available tables.
DB2.Database	Connects to an IBM Db2 database and returns a table of available tables and views.
Excel.CurrentWorkbook	Returns the tables, named ranges, and connections from the current Excel workbook.
Exchange.Contents	Connects to a Microsoft Exchange server and returns a table of mailbox folders and their contents.
File.Contents	Returns the contents of the file at the given path as a binary value.
Folder.Contents	Returns a table of files and subfolders found in the specified folder path, including file metadata and content.
Folder.Files	Returns a table of all files in the specified folder and its subfolders, including file metadata and binary content.
Hdfs.Contents	Connects to a Hadoop Distributed File System (HDFS) path and returns a table of files and folders.
Hdfs.Files	Returns a table of files from the specified HDFS path, including file metadata and binary content.
HdInsight.Files	Returns a table of files from the specified Azure HDInsight cluster storage path.
HdInsight.Contents	Connects to an Azure HDInsight cluster and returns a table of available containers and files.
HdInsight.Containers	Returns a table of storage containers associated with the given Azure HDInsight cluster.
Web.Page	Downloads a web page from the given URL and returns its HTML content parsed into a table of elements.
MySQL.Database	Connects to a MySQL database and returns a table of available tables and views.
OData.Feed	Connects to an OData service and returns a table of available entity sets from the service’s feed.
Odbc.Query	Executes a SQL query against an ODBC data source using the given connection string, and returns the results as a table.
Odbc.DataSource	Connects to an ODBC data source using the given connection string and returns a table of available tables.
Odbc.InferOptions	Returns a record of inferred ODBC capability options for the given connection string.
OleDb.Query	Executes a SQL query against an OLE DB data source using the given connection string, and returns the results as a table.
OleDb.DataSource	Connects to an OLE DB data source using the given connection string and returns a table of available tables.
Oracle.Database	Connects to an Oracle database and returns a table of available tables and views.
PostgreSQL.Database	Connects to a PostgreSQL database and returns a table of available tables and views.
Salesforce.Data	Connects to Salesforce and returns a table of available Salesforce objects.
Salesforce.Reports	Connects to Salesforce and returns a table of available Salesforce reports.
SapBusinessWarehouse.Cubes	Connects to an SAP Business Warehouse server and returns a table of available InfoCubes and queries.
SapHana.Database	Connects to an SAP HANA database and returns a table of available schemas and views.
SharePoint.Contents	Connects to a SharePoint site and returns a table of available lists and document libraries.
SharePoint.Files	Returns a table of files from the given SharePoint site, including file metadata and binary content.
SharePoint.Tables	Connects to a SharePoint site and returns a table of SharePoint list items.
Geography.FromWellKnownText	Converts a Well-Known Text (WKT) string into a geography value representing a spatial object on the Earth’s surface.
Geography.ToWellKnownText	Converts a geography value into its Well-Known Text (WKT) string representation.
GeographyPoint.From	Creates a geography point value from the given longitude and latitude coordinates.
Geometry.FromWellKnownText	Converts a Well-Known Text (WKT) string into a planar geometry value.
Geometry.ToWellKnownText	Converts a planar geometry value into its Well-Known Text (WKT) string representation.
GeometryPoint.From	Creates a planar geometry point value from the given X and Y coordinates.
Sql.Database	Connects to a SQL Server database and returns a table of available tables and views.
Sql.Databases	Returns a table of databases available on the given SQL Server instance.
Sybase.Database	Connects to a Sybase database and returns a table of available tables and views.
Teradata.Database	Connects to a Teradata database and returns a table of available tables and views.
Web.Contents	Downloads content from the given URL and returns it as a binary value.
Web.Headers	Returns the HTTP response headers for the given URL as a record.
Soda.Feed	Connects to a Socrata Open Data API (SODA) endpoint and returns a table of available datasets.
WebAction.Request	Creates an action that, when run, returns the HTTP response for the given URL and method as a binary value.
Web.BrowserContents	Returns the HTML source of the given URL after rendering it in a browser, including dynamically loaded content.

Enumerations and constant values

Power Query Function Name	Description
RelativePosition.Type	The enumeration type for relative positions, used by functions that locate items from the start or end of a sequence.
RelativePosition.FromStart	A RelativePosition value indicating the position is measured from the start of the sequence.
RelativePosition.FromEnd	A RelativePosition value indicating the position is measured from the end of the sequence.
TextEncoding.Type	The enumeration type for text encodings, used by functions that read or write text with a specific character set.
TextEncoding.Utf8	A TextEncoding value specifying UTF-8 encoding.
TextEncoding.Utf16	A TextEncoding value specifying UTF-16 encoding.
TextEncoding.Ascii	A TextEncoding value specifying ASCII encoding.
TextEncoding.Unicode	A TextEncoding value specifying Unicode (UTF-16 LE) encoding.
TextEncoding.BigEndianUnicode	A TextEncoding value specifying big-endian UTF-16 encoding.
TextEncoding.Windows	A TextEncoding value specifying Windows default (Windows-1252) encoding.
Culture.Current	Returns the current culture of the M environment as a text value, used in locale-sensitive formatting and parsing functions.
Day.Type	The enumeration type for days of the week, used by functions that work with day-of-week values.
Day.Sunday	A Day value representing Sunday.
Day.Monday	A Day value representing Monday.
Day.Tuesday	A Day value representing Tuesday.
Day.Wednesday	A Day value representing Wednesday.
Day.Thursday	A Day value representing Thursday.
Day.Friday	A Day value representing Friday.
Day.Saturday	A Day value representing Saturday.
JoinKind.Type	The enumeration type that specifies the kind of join used by table join functions such as Table.Join and Table.NestedJoin.
JoinKind.Inner	A JoinKind value specifying an inner join, which keeps only rows with matching keys in both tables.
JoinKind.LeftOuter	A JoinKind value specifying a left outer join, which keeps all rows from the left table and matching rows from the right.
JoinKind.RightOuter	A JoinKind value specifying a right outer join, which keeps all rows from the right table and matching rows from the left.
JoinKind.FullOuter	A JoinKind value specifying a full outer join, which keeps all rows from both tables regardless of whether they match.
JoinKind.LeftAnti	A JoinKind value specifying a left anti join, which keeps only rows from the left table that have no matching key in the right table.
JoinKind.RightAnti	A JoinKind value specifying a right anti join, which keeps only rows from the right table that have no matching key in the left table.
JoinKind.LeftSemi	A JoinKind value specifying a left semi join, which keeps only rows from the left table that have at least one matching key in the right table.
JoinKind.RightSemi	A JoinKind value specifying a right semi join, which keeps only rows from the right table that have at least one matching key in the left table.
MissingField.Type	The enumeration type that controls how functions handle missing fields in a record or table column.
MissingField.Error	A MissingField value that causes an error to be raised when a referenced field or column does not exist.
MissingField.Ignore	A MissingField value that silently ignores missing fields, as if they were not specified.
MissingField.UseNull	A MissingField value that returns null for any field or column that does not exist.
GroupKind.Type	The enumeration type that specifies how grouping is applied in Table.Group, either globally across the whole table or locally on consecutive rows.
GroupKind.Global	A GroupKind value that groups all rows with the same key together, regardless of their order in the table.
GroupKind.Local	A GroupKind value that groups only consecutive rows with the same key, producing a new group whenever the key changes.
RoundingMode.Type	The enumeration type for rounding modes, used by Number.Round and related functions to control how halfway values are rounded.
RoundingMode.Up	A RoundingMode value that rounds toward positive infinity.
RoundingMode.Down	A RoundingMode value that rounds toward negative infinity.
RoundingMode.AwayFromZero	A RoundingMode value that rounds away from zero, so 0.5 becomes 1 and -0.5 becomes -1.
RoundingMode.TowardZero	A RoundingMode value that rounds toward zero, truncating the fractional part.
RoundingMode.ToEven	A RoundingMode value that rounds to the nearest even number when the value is exactly halfway, also known as banker’s rounding.
Precision.Type	The enumeration type that specifies numeric precision for arithmetic operations, choosing between double and decimal arithmetic.
Precision.Double	A Precision value specifying IEEE 754 double-precision floating-point arithmetic.
Precision.Decimal	A Precision value specifying exact decimal arithmetic, which avoids floating-point rounding errors.
BinaryEncoding.Type	The enumeration type for binary-to-text encoding schemes, used by functions like Binary.ToText and Binary.FromText.
BinaryEncoding.Hex	A BinaryEncoding value specifying hexadecimal encoding.
BinaryEncoding.Base64	A BinaryEncoding value specifying Base64 encoding.
Compression.Type	The enumeration type for compression algorithms, used by functions that read or write compressed binary data.
Compression.None	A Compression value specifying no compression.
Compression.GZip	A Compression value specifying GZip compression.
Compression.Deflate	A Compression value specifying Deflate compression.
Compression.Snappy	A Compression value specifying Snappy compression.
Compression.Brotli	A Compression value specifying Brotli compression.
Compression.LZ4	A Compression value specifying LZ4 compression.
Compression.Zstandard	A Compression value specifying Zstandard (zstd) compression.
Order.Type	The enumeration type for sort order, used by table and list sorting functions.
Order.Ascending	An Order value specifying ascending sort order, from smallest to largest.
Order.Descending	An Order value specifying descending sort order, from largest to smallest.
Occurrence.Type	The enumeration type that specifies which occurrence of a match to return or how many times a pattern may appear, used by text and list search functions.
Occurrence.All	An Occurrence value indicating that all occurrences of the pattern should be returned.
Occurrence.First	An Occurrence value indicating that only the first occurrence of the pattern should be returned.
Occurrence.Last	An Occurrence value indicating that only the last occurrence of the pattern should be returned.
PercentileMode.Type	The enumeration type for percentile calculation methods, used by List.Percentile to match Excel or SQL behavior.
PercentileMode.ExcelInc	A PercentileMode value using Excel’s inclusive interpolation method, equivalent to PERCENTILE.INC.
PercentileMode.ExcelExc	A PercentileMode value using Excel’s exclusive interpolation method, equivalent to PERCENTILE.EXC.
PercentileMode.SqlDisc	A PercentileMode value using the SQL discrete percentile method, which returns an actual value from the list.
PercentileMode.SqlCont	A PercentileMode value using the SQL continuous percentile method, which interpolates between values.
TimeZone.Current	Returns the current time zone offset of the M environment as a duration value, used when converting between local and UTC times.
BufferMode.Type	The enumeration type that controls when data is buffered into memory for Binary.Buffer and Table.Buffer.
BufferMode.Eager	A BufferMode value that loads all data into memory immediately when buffering is requested.
BufferMode.Delayed	A BufferMode value that defers loading data into memory until it is first accessed.
Progress.DataSourceProgress	A progress constant used to signal data source query progress during evaluation, surfaced in the Power Query editor’s progress indicator.
AccessControlEntry.Type	The enumeration type for access control entry fields, used with row-level security and data access control in Power Query.
AccessControlEntry.ConditionContextType	An AccessControlEntry field key identifying the context type associated with an access control condition.
AccessControlEntry.ConditionToIdentities	An AccessControlEntry field key identifying the function that maps an access control condition to a set of identities.
AccessControlKind.Type	The enumeration type that specifies whether an access control entry grants or denies access.
AccessControlKind.Allow	An AccessControlKind value indicating the entry grants access.
AccessControlKind.Deny	An AccessControlKind value indicating the entry denies access.
IdentityProvider.Type	The enumeration type for identity provider configurations used in data access control.
IdentityProvider.Default	An IdentityProvider value representing the default identity provider for the current environment.
Identity.Type	The enumeration type for identity record fields used in access control.
Identity.From	An Identity field key identifying the source of an identity claim.
Identity.IsMemberOf	An Identity field key pointing to a function that checks whether the identity belongs to a given group.
ByteOrder.Type	The enumeration type for byte order (endianness), used by BinaryFormat functions that read multi-byte numeric values.
ByteOrder.LittleEndian	A ByteOrder value specifying little-endian byte order, where the least significant byte comes first.
ByteOrder.BigEndian	A ByteOrder value specifying big-endian byte order, where the most significant byte comes first.
Occurrence.Optional	An Occurrence value used in binary format patterns indicating the item may appear zero or one time.
Occurrence.Required	An Occurrence value used in binary format patterns indicating the item must appear exactly once.
Occurrence.Repeating	An Occurrence value used in binary format patterns indicating the item may appear zero or more times.
BinaryOccurrence.Type	The enumeration type for occurrence constraints in binary format field definitions.
BinaryOccurrence.Optional	A BinaryOccurrence value indicating a binary field may be absent.
BinaryOccurrence.Required	A BinaryOccurrence value indicating a binary field must be present.
BinaryOccurrence.Repeating	A BinaryOccurrence value indicating a binary field may repeat zero or more times.
TraceLevel.Type	The enumeration type for diagnostic trace levels, used by Diagnostics.Trace to control message verbosity.
TraceLevel.Critical	A TraceLevel value for critical failures that require immediate attention.
TraceLevel.Error	A TraceLevel value for error conditions that indicate a failure in the current operation.
TraceLevel.Warning	A TraceLevel value for warnings about unexpected conditions that did not cause a failure.
TraceLevel.Information	A TraceLevel value for general informational messages about normal operation.
TraceLevel.Verbose	A TraceLevel value for detailed diagnostic messages, typically used during development and debugging.
ExtraValues.Type	The enumeration type that controls how Table.FromList and similar functions handle rows with more values than expected columns.
ExtraValues.List	An ExtraValues value that collects any extra column values into a list in the last column.
ExtraValues.Ignore	An ExtraValues value that silently discards any values beyond the expected number of columns.
ExtraValues.Error	An ExtraValues value that raises an error when a row contains more values than the defined columns.
QuoteStyle.Type	The enumeration type for quote handling styles used by Csv.Document and related text parsing functions.
QuoteStyle.None	A QuoteStyle value that disables quote processing, treating quote characters as plain text.
QuoteStyle.Csv	A QuoteStyle value that applies standard CSV quoting rules, where a doubled quote character inside a quoted field is treated as a literal quote.
CsvStyle.Type	The enumeration type that controls when fields are quoted when writing CSV output.
CsvStyle.QuoteAlways	A CsvStyle value that wraps every field in quotes regardless of content.
CsvStyle.QuoteAfterDelimiter	A CsvStyle value that quotes a field only when its content starts with the delimiter character.
LimitClauseKind.Type	The enumeration type for SQL row-limit clause syntax variants, used when building query-folding SQL for different database dialects.
LimitClauseKind.None	A LimitClauseKind value indicating the data source does not support a row-limit clause.
LimitClauseKind.Top	A LimitClauseKind value indicating the data source uses a TOP n clause to limit rows, as in T-SQL.
LimitClauseKind.Limit	A LimitClauseKind value indicating the data source uses a LIMIT n clause to limit rows.
LimitClauseKind.LimitOffset	A LimitClauseKind value indicating the data source uses a LIMIT n OFFSET m clause for paged queries.
LimitClauseKind.AnsiSql2008	A LimitClauseKind value indicating the data source uses the ANSI SQL 2008 FETCH FIRST n ROWS ONLY syntax.
JoinAlgorithm.Type	The enumeration type for join algorithm hints, used by Table.Join to suggest how the engine should perform a merge.
JoinAlgorithm.Dynamic	A JoinAlgorithm value letting the engine choose the best algorithm automatically.
JoinAlgorithm.PairwiseHash	A JoinAlgorithm value requesting a pairwise hash join.
JoinAlgorithm.SortMerge	A JoinAlgorithm value requesting a sort-merge join, which first sorts both tables by the key columns.
JoinAlgorithm.LeftHash	A JoinAlgorithm value requesting a hash join that builds the hash table from the left input.
JoinAlgorithm.RightHash	A JoinAlgorithm value requesting a hash join that builds the hash table from the right input.
JoinAlgorithm.LeftIndex	A JoinAlgorithm value requesting an index-based join using an index on the left table.
JoinAlgorithm.RightIndex	A JoinAlgorithm value requesting an index-based join using an index on the right table.
JoinSide.Type	The enumeration type identifying which side of a join a key column belongs to.
JoinSide.Left	A JoinSide value indicating the left table in a join operation.
JoinSide.Right	A JoinSide value indicating the right table in a join operation.
RankKind.Type	The enumeration type for ranking methods, used by Table.AddRankColumn to control how ties are handled.
RankKind.Competition	A RankKind value using competition ranking, where tied items share the same rank and the next rank skips ahead by the number of ties.
RankKind.Dense	A RankKind value using dense ranking, where tied items share the same rank and the next rank is always one higher.
RankKind.Ordinal	A RankKind value using ordinal ranking, where every item gets a unique rank with no ties.
ODataOmitValues.Type	The enumeration type that controls how null and default values are omitted in OData query results.
ODataOmitValues.Nulls	An ODataOmitValues value that instructs the OData service to omit null-valued properties from the response.
SapBusinessWarehouseExecutionMode.Type	The enumeration type for SAP Business Warehouse query execution modes, used in SAP BW connector options.
SapBusinessWarehouseExecutionMode.DataStream	An execution mode value that retrieves SAP BW data using the DataStream protocol.
SapBusinessWarehouseExecutionMode.BasXml	An execution mode value that retrieves SAP BW data using BasXml format.
SapBusinessWarehouseExecutionMode.BasXmlGzip	An execution mode value that retrieves SAP BW data using BasXml format with GZip compression.
SapHanaRangeOperator.Type	The enumeration type for comparison operators used in SAP HANA range input parameters.
SapHanaRangeOperator.GreaterThan	A SapHanaRangeOperator value representing the greater-than comparison.
SapHanaRangeOperator.LessThan	A SapHanaRangeOperator value representing the less-than comparison.
SapHanaRangeOperator.GreaterThanOrEquals	A SapHanaRangeOperator value representing the greater-than-or-equal comparison.
SapHanaRangeOperator.LessThanOrEquals	A SapHanaRangeOperator value representing the less-than-or-equal comparison.
SapHanaRangeOperator.Equals	A SapHanaRangeOperator value representing an equality comparison.
SapHanaRangeOperator.NotEquals	A SapHanaRangeOperator value representing a not-equal comparison.
SapHanaDistribution.Type	The enumeration type for SAP HANA connection distribution modes, used in SAP HANA connector options.
SapHanaDistribution.Off	A SapHanaDistribution value that disables connection distribution across SAP HANA nodes.
SapHanaDistribution.Connection	A SapHanaDistribution value that distributes connections across SAP HANA nodes at the connection level.
SapHanaDistribution.Statement	A SapHanaDistribution value that distributes work across SAP HANA nodes at the statement level.
SapHanaDistribution.All	A SapHanaDistribution value that enables all available distribution modes.
WebMethod.Type	The enumeration type for HTTP request methods, used by Web.Contents and related web connector functions.
WebMethod.Delete	A WebMethod value specifying the HTTP DELETE method.
WebMethod.Get	A WebMethod value specifying the HTTP GET method.
WebMethod.Head	A WebMethod value specifying the HTTP HEAD method, which retrieves headers only without a response body.
WebMethod.Patch	A WebMethod value specifying the HTTP PATCH method.
WebMethod.Post	A WebMethod value specifying the HTTP POST method.
WebMethod.Put	A WebMethod value specifying the HTTP PUT method.

Of course, you don’t need to know all of these functions, and even the most advanced Power Query users would only end up using a handful of these functions regularly.

Other Power Query articles you may also like:

• VLOOKUP in Power Query
• IF Then Else in Power Query
• Concatenate in Power Query (Columns, Text, Numbers)