Return to: Calculated Member Builder Function List
Returns the level whose name is specified by a string expression, or the level whose position in a dimension is specified by a zero-based numeric expression.
| String Expressions | Dimension Indexes | |
|---|---|---|
| Syntax | Levels(«String Expression») | «Dimension».Levels(«Numeric Expression») |
| Remarks | Returns the level whose name is specified by «String Expression». Typically used with user-defined functions. | Returns the «Dimension» level specified by «Numeric Expression». |
| Example | Levels(“Year”) returns the Year level. |
If the Time dimension has levels All, Year, Quarter, Month, Week, and Day, then:
returns the Quarter level. |