PQM.guide
Home
Sample Tables
Resources
Concepts
Functions by Category
  • Table.AddColumn
  • Table.AddIndexColumn
  • Table.Buffer
  • Table.ColumnNames
  • Table.Combine
  • Table.Distinct
  • Table.DuplicateColumn
  • Table.ExpandRecordColumn
  • Table.ExpandTableColumn
  • Table.FillDown
  • Table.FillUp
  • Table.FirstN
  • Table.FromRecords
  • Table.Group
  • Table.HasColumns
  • Table.IsEmpty
  • Table.LastN
  • Table.NestedJoin
  • Table.Pivot
  • Table.PrefixColumns
  • Table.Profile
  • Table.PromoteHeaders
  • Table.Range
  • Table.RemoveColumns
  • Table.RemoveDuplicates
  • Table.RenameColumns
  • Table.ReorderColumns
  • Table.ReplaceValue
  • Table.ReverseRows
  • Table.RowCount
  • Table.Schema
  • Table.SelectColumns
  • Table.SelectRows
  • Table.Skip
  • Table.Sort
  • Table.TransformColumns
  • Table.TransformColumnTypes
  • Table.Unpivot
  • Table.UnpivotOtherColumns

List Functions

Functions for creating, manipulating, and transforming lists.

  • List.Accumulate
    Accumulates a result by applying a function to each item in a list, starting from an initial seed value.
  • List.Combine
    Merges multiple lists into a single list.
  • List.Contains
    Returns true if a list contains a specified value.
  • List.ContainsAny
    Returns true if a list contains any of the values in another list.
  • List.Count
    Returns the number of items in a list.
  • List.Distinct
    Returns a list with duplicate values removed.
  • List.First
    Returns the first item in a list, or a default value if the list is empty.
  • List.Generate
    Generates a list of values using an initial value, a condition, a next function, and an optional selector.
  • List.Last
    Returns the last item in a list, or a default value if the list is empty.
  • List.Range
    Returns a subset of items from a list starting at a given offset.
  • List.RemoveItems
    Removes all occurrences of specified values from a list.
  • List.Select
    Returns items from a list that match a condition.
  • List.Sort
    Sorts the items in a list according to the specified criteria.
  • List.Sum
    Returns the sum of all items in a list.
  • List.Transform
    Applies a function to each item in a list and returns the results.