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

Time Functions

Functions for creating and manipulating time values.

  • #time
    Creates a time value from hour, minute, and second components.
  • Time.EndOfHour
    Returns the last moment of the hour for the given time or datetime value.
  • Time.From
    Converts a value to a time.
  • Time.FromText
    Converts a text representation of a time to a time value.
  • Time.Hour
    Returns the hour component from a time, datetime, or datetimezone value.
  • Time.Minute
    Returns the minute component from a time, datetime, or datetimezone value.
  • Time.Second
    Returns the second component from a time, datetime, or datetimezone value.
  • Time.StartOfHour
    Returns the first moment of the hour for the given time or datetime value.
  • Time.ToRecord
    Converts a time value to a record containing its parts.
  • Time.ToText
    Converts a time value to a text string.