PARTITIONBY DAX Function (Filter)
The columns used to determine how to partition the data. Can only be used within a Window function.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| PartitionBy_ColumnName | Optional Repeatable |
The name of an existing column to be used to partition the window function’s Relation. |
Return values
This function does not return a value.
Remarks
This function can only be used within a window function expression (INDEX, OFFSET, WINDOW).
Related articles
Learn more about PARTITIONBY in the following articles:
-
Introducing window functions in DAX
In December 2022, DAX was enriched with window functions: INDEX, OFFSET, and WINDOW. This article introduces the syntax and the basic functionalities of these new features. » Read more
Related functions
Other related functions are:
Last update: Jun 10, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/partitionby-function-dax