CURRENTGROUP
Returns a set of rows from the table argument of a GROUPBY expression that belong to the current row of the GROUPBY result.
Syntax
CURRENTGROUP ( )
Parameters
None
Return value
The rows in the table argument of the GROUPBY function corresponding to one group of values of the groupBy_columnName arguments.
Remarks
This function can only be used within a GROUPBY expression.
This function takes no arguments and is only supported as the first argument to one of the following aggregation functions: AVERAGEX, COUNTAX, COUNTX, GEOMEANX, MAXX, MINX, PRODUCTX, STDEVX.S, STDEVX.P, SUMX, VARX.S, VARX.P.
Example
See GROUPBY.
Feedback
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: https://aka.ms/ContentUserFeedback.
Submit and view feedback for