dtMinusMonths (MDX+)

Returns the member matching current member minus 'count' number of months.

Parameters

Name Type Cardinality Default value
time member  set-member-expression  one   
count  numeric-expression  one   

Return

member|set-members

Description

Returns the member matching current member minus 'count' number of months.
If the member is missing it will return NULL.

dtMinusMonths( [Time].[Calendar].[Day].[31 Mar 2006], 1 ) will return [Time].[Calendar].[Day].[28 Feb 2006] the last day of the month as the 31th does not exist.

When applied to a set it will return a set that is the result of applying this function on each member
of the input set. When the resulting member is missing it will be ignored.

See Also

Lag dtAsOf dtAsOfToday dtNextDay dtNextWeek dtNextMonth dtNextQuarter dtNextYear dtPreviousDay dtPreviousWeek dtPreviousMonth dtPreviousQuarter dtPreviousYear dtPlusDays dtPlusWeeks dtPlusMonths dtPlusQuarters dtPlusYears dtMinusDays dtMinusWeeks dtMinusMonths dtMinusQuarters dtMinusYears dtFirstDayOfWeekOfMonth dtFirstDayOfWeekOfQuarter dtFirstDayOfWeekOfYear dtLastDayOfWeekOfMonth dtLastDayOfWeekOfQuarter dtLastDayOfWeekOfYear dtNthDayOfWeekOfMonth dtNthDayOfWeekOfQuarter dtNthDayOfWeekOfYear dtDatesWeek dtDatesWeekend dtDatesWorkweek dtDatesWtd dtDatesMtd dtDatesQtd dtDatesYtd dtDatesWfd dtDatesMfd dtDatesQfd dtDatesYfd dtWithDayOfWeek dtWithDayOfMonth dtWithDayOfYear dtWithMonthOfYear dtWithYear dtWithTime

Examples

Special Examples (errors, null, ...)

Since Version

6.0

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.