ROLLUPGROUP
Applies to: Calculated column Calculated table Measure Visual calculation
Modifies the behavior of the SUMMARIZE and SUMMARIZECOLUMNS functions by adding rollup rows to the result on columns defined by the the groupBy_columnName parameter. This function can only be used within a SUMMARIZE or SUMMARIZECOLUMNS expression.
Syntax
ROLLUPGROUP ( <groupBy_columnName> [, <groupBy_columnName> [, … ] ] )
Parameters
Term | Definition |
---|---|
groupBy_columnName | The qualified name of an existing column or ROLLUPGROUP function to be used to create summary groups based on the values found in it. This parameter cannot be an expression. |
Return value
This function does not return a value. It marks a set of columns to be treated as a single group during subtotaling by ROLLUP or ROLLUPADDISSUBTOTAL.
Remarks
ROLLUPGROUP can only be used as a groupBy_columnName argument to ROLLUP, ROLLUPADDISSUBTOTAL, or ROLLUPISSUBTOTAL.
Example
See SUMMARIZE and SUMMARIZECOLUMNS.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for