Skip to main content

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])