dtWithDayOfWeek (MDX+)

Returns the member changing the current member's day of the week.

Parameters

Name	Type	Cardinality	Default value
	member-expression	one
day of the week [1-7]	numeric-expression	one

Return

member

Description

This functions returns a member changing the current member's day of the week.

dtWithDayOfWeek( [Time].[Calendar].[Day].[6 Jun 2006], 5 ) will return the 9th that is the Friday of the week.

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

dtWithDayOfWeek(member,numeric)

Returns the member defined by the Tuesday of the week defined by the 17th November 2016.

Query

dtWithDayOfWeek([Calendar].[Day].[17 Nov 2016],2)

Result

{ 
  [Calendar].[Calendar].[Day].&[2016-11-15]
}

Assertion : MDX Equals

[Calendar].[Day].[15 Nov 2016]

Assertion : MDX Equals

[Calendar].[Day].[17 Nov 2016].dtWithDayOfWeek(2)

Special Examples (errors, null, ...)

dtWithDayOfWeek(NULL,numeric) - return NULL

dtWithDayOfWeek(member,numeric) - out of bounds

dtWithDayOfWeek(member,numeric) - member not of level day

dtWithDayOfWeek(member,numeric) - member not a date time type

Since Version

6.0

XMLA Properties

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