Syntax

Year(Measure_Expression)

Input Parameters

Measure_Expression

A valid Multidimensional Measure that returns a date or datetime value.

Return Value

Returns the Year component of the date measure as an integer.

Examples

Return the Year component of the [MaxDueDate] measure:

Year([Measures].[MaxDueDate])