Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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