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

Date Functions

Functions for creating, manipulating, and extracting parts of date values.

  • Date.AddDays
    Adds a specified number of days to a date value.
  • Date.AddMonths
    Adds a specified number of months to a date value.
  • Date.AddYears
    Adds a specified number of years to a date value.
  • Date.Day
    Returns the day of the month from a date value.
  • Date.DayOfWeek
    Returns the day of the week for a given date.
  • Date.EndOfMonth
    Returns the last day of the month for a given date.
  • Date.EndOfYear
    Returns the last day of the year for a given date.
  • Date.From
    Converts a value to a date.
  • Date.Month
    Returns the month from a date value.
  • Date.StartOfMonth
    Returns the first day of the month for a given date.
  • Date.StartOfYear
    Returns the first day of the year for a given date.
  • Date.Year
    Returns the year from a date value.