dtMinusDays (MDX+)
Returns the member matching current member minus 'count' number of days.
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 days.
If the member is missing it will return NULL.
dtMinusDays( [Time].[Calendar].[Day].[10 Jun 2006], 8 ) will return [Time].[Calendar].[Day].[2 Jun 2006]
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 dtDatesItd 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.