dtLastDayOfWeekOfYear (MDX+)

Returns the member matching the last day of the week of the year (e.g. last Saturday), null if missing.

Parameters

Return

member|set-members

Description

This functions returns the member matching the last day of the week of the year.
If the member is missing it will return NULL.

dtLastDayOfWeekOfYear( [Calendar].[Calendar].[Day].[30 Nov 2016], 2 ) will return the last Tuesday of the year (i.e., [Time].[Calendar].[Day].[27 Dec 2016]).

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

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

dtLastDayOfWeekOfYear( [Calendar].[Day].[15 Jan 2016], 1)

{ 
  [Calendar].[Calendar].[Day].&[2016-12-26]
}

[Calendar].[Day].[26 Dec 2016]

dtLastDayOfWeekOfYear( { [Calendar].[Day].[15 Jan 2016], [Calendar].[Day].[15 Jan 2017] }, 1)

{ 
  [Calendar].[Calendar].[Day].&[2016-12-26], 
  [Calendar].[Calendar].[Day].&[2017-12-25]
}

{ [Calendar].[Day].[26 Dec 2016],  [Calendar].[Day].[25 Dec 2017] }

Special Examples (errors, null, ...)

dtLastDayOfWeekOfYear( NULL, 1)

NULL

dtLastDayOfWeekOfYear( [Geography].[Geo].[Paris], 1)

Error Code    : OLAP_LEVEL_DATETIME_KEYTYPE_EXPECTED
Error Message : dtLastDayOfWeekOfYear() : The level ('[Geography].[Geo].[City]') is expected with a date or date time key type (got :'[STRING]')

dtLastDayOfWeekOfYear( { [Geography].[Geo].[Paris] }, 1 )

Error Code    : OLAP_LEVEL_DATETIME_KEYTYPE_EXPECTED
Error Message : dtLastDayOfWeekOfYear() : The level ('[Geography].[Geo].[City]') is expected with a date or date time key type (got :'[STRING]')

Since Version

6.0

XMLA Properties

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