PARTITIONBY

Updated on

PARTITIONBY is a DAX function that specifies the columns used to partition data, used within Window functions.

Syntax

PARTITIONBY( [ PartitionBy_ColumnName, ... ] )
Argument Properties Description
PartitionBy_ColumnName Optional, Repeatable A column used to determine how to partition the data.

Return Values

This function does not return a value.

Remarks

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

Example

See OFFSET.

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/partitionby-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy