Month

Syntax

Month(Measure_Expression)

Input Parameters

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

Return Value

Returns the Month component of the date measure as an integer between 1 and 12.

Examples

Return the Month component of the [MaxDueDate] measure:

Month([Measures].[MaxDueDate])