PQM.guide
Home
Start Here
Sample Tables
Resources
Concepts
Patterns
MCP Server
Format M
Functions by Category
  • Cube.AddAndExpandDimensionColumn
  • Cube.AddMeasureColumn
  • Cube.ApplyParameter
  • Cube.AttributeMemberId
  • Cube.AttributeMemberProperty
  • Cube.CollapseAndRemoveColumns
  • Cube.Dimensions
  • Cube.DisplayFolders
  • Cube.MeasureProperties
  • Cube.MeasureProperty
  • Cube.Measures
  • Cube.Parameters
  • Cube.Properties
  • Cube.PropertyKey
  • Cube.ReplaceDimensions
  • Cube.Transform
  • #table
  • Table.AddColumn
  • Table.AddFuzzyClusterColumn
  • Table.AddIndexColumn
  • Table.AddJoinColumn
  • Table.AddKey
  • Table.AddRankColumn
  • Table.AggregateTableColumn
  • Table.AlternateRows
  • Table.ApproximateRowCount
  • Table.Buffer
  • Table.Column
  • Table.ColumnCount
  • Table.ColumnNames
  • Table.ColumnsOfType
  • Table.Combine
  • Table.CombineColumns
  • Table.CombineColumnsToRecord
  • Table.ConformToPageReader
  • Table.Contains
  • Table.ContainsAll
  • Table.ContainsAny
  • Table.DemoteHeaders
  • Table.Distinct
  • Table.DuplicateColumn
  • Table.ExpandListColumn
  • Table.ExpandRecordColumn
  • Table.ExpandTableColumn
  • Table.FillDown
  • Table.FillUp
  • Table.FilterWithDataTable
  • Table.FindText
  • Table.First
  • Table.FirstN
  • Table.FirstValue
  • Table.FromColumns
  • Table.FromList
  • Table.FromPartitions
  • Table.FromRecords
  • Table.FromRows
  • Table.FromValue
  • Table.FuzzyGroup
  • Table.FuzzyJoin
  • Table.FuzzyNestedJoin
  • Table.Group
  • Table.HasColumns
  • Table.InsertRows
  • Table.IsDistinct
  • Table.IsEmpty
  • Table.Join
  • Table.Keys
  • Table.Last
  • Table.LastN
  • Table.MatchesAllRows
  • Table.MatchesAnyRows
  • Table.Max
  • Table.MaxN
  • Table.Min
  • Table.MinN
  • Table.NestedJoin
  • Table.Partition
  • Table.PartitionKey
  • Table.PartitionValues
  • Table.Pivot
  • Table.PositionOf
  • Table.PositionOfAny
  • Table.PrefixColumns
  • Table.Profile
  • Table.PromoteHeaders
  • Table.Range
  • Table.RemoveColumns
  • Table.RemoveFirstN
  • Table.RemoveLastN
  • Table.RemoveMatchingRows
  • Table.RemoveRows
  • Table.RemoveRowsWithErrors
  • Table.RenameColumns
  • Table.ReorderColumns
  • Table.Repeat
  • Table.ReplaceErrorValues
  • Table.ReplaceKeys
  • Table.ReplaceMatchingRows
  • Table.ReplacePartitionKey
  • Table.ReplaceRelationshipIdentity
  • Table.ReplaceRows
  • Table.ReplaceValue
  • Table.ReverseRows
  • Table.RowCount
  • Table.Schema
  • Table.SelectColumns
  • Table.SelectRows
  • Table.SelectRowsWithErrors
  • Table.SingleRow
  • Table.Skip
  • Table.Sort
  • Table.Split
  • Table.SplitAt
  • Table.SplitColumn
  • Table.StopFolding
  • Table.ToColumns
  • Table.ToList
  • Table.ToRecords
  • Table.ToRows
  • Table.TransformColumnNames
  • Table.TransformColumns
  • Table.TransformColumnTypes
  • Table.TransformRows
  • Table.Transpose
  • Table.Unpivot
  • Table.UnpivotOtherColumns
  • Table.View
  • Table.ViewError
  • Table.ViewFunction
  • Table.WithErrorContext
  • Tables.GetRelationships

Function Functions

Functions for working with function values.

  • Function.From
    Creates a typed function wrapper that converts a unary function to match a specific function type signature.
  • Function.Invoke
    Invokes a function with a list of arguments.
  • Function.InvokeAfter
    Returns the result of invoking a function after a specified duration delay has passed.
  • Function.InvokeWithErrorContext
    Invokes a function and attaches additional error context text to any error raised during execution. Intended for internal use only.
  • Function.IsDataSource
    Returns whether or not a function is considered a data source.
  • Function.ScalarVector
    Creates a scalar function that invokes a vector function behind the scenes, enabling batch processing when applied row-by-row across a table.