ISSUBTOTAL
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Creates another column in a SUMMARIZE expression that returns True if the row contains subtotal values for the column given as argument, otherwise returns False.
Syntax
ISSUBTOTAL(<columnName>)
With SUMMARIZE,
SUMMARIZE(<table>, <groupBy_columnName>[, <groupBy_columnName>]…[, ROLLUP(<groupBy_columnName>[,< groupBy_columnName>…])][, <name>, {<expression>|ISSUBTOTAL(<columnName>)}]…)
Parameters
Term | Definition |
---|---|
columnName | The name of any column in table of the SUMMARIZE function or any column in a related table to table. |
Return value
A True value if the row contains a subtotal value for the column given as argument, otherwise returns False.
Remarks
This function can only be used in the expression of a SUMMARIZE function.
This function must be preceded by the name of the Boolean column.
Example
See SUMMARIZE.
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir