partitionby-function-dax.md

description	title
Learn more about: PARTITIONBY	PARTITIONBY function (DAX) | Microsoft Docs

PARTITIONBY

[!INCLUDEapplies-to-measures-columns-tables-visual-calculations]

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