Month
Returns an integer containing a whole number between 1 and 12, representing the month of the year.
Syntax
Month(Date_Expression)
Arguments
Date_Expression | MDX expression that returns a date value. |
|---|
Examples
Month from the current date
Get the month from the current date.
Month(Now())
Month from issue created date
Get the month from the issue property "Issue created date. " It will work if the issue itself is present in the report or formula.
Month([Measures].[Issue created date])
Month of the selected time period
This formula extracts the month number from the start date of the currently selected time period.
Month([Time].CurrentHierarchyMember.StartDate)