Edit

Share via

PARTITIONBY

  • Article

Applies to: Calculated column Calculated table Measure Visual calculation

Defines the columns that are used to partition a window function’s relation parameter.

Syntax

PARTITIONBY ( [<partitionBy_columnName>[, partitionBy_columnName [, …]]] )

Parameters

Term Definition
partitionBy_columnName (Optional) The name of an existing column to be used to partition the window function’s relation.
RELATED() may also be used to refer to a column in a table related to relation.

Return value

This function does not return a value.

Remarks

This function can only be used within a window function expression.

Example

See OFFSET.

Related content

Understanding ORDERBY, PARTITIONBY, and MATCHBY functions INDEX OFFSET ORDERBY MATCHBY WINDOW RANK ROWNUMBER