Untitled

SELECT the same day for the last n weeks

SELECT

{

[Date].[Year-Month-Day].[Day].&[2007]&[10]&[2],

ParallelPeriod([Date].[Year-Month-Day].[Day],7, [Order Date].[Year-Month-Day].[Day].&[2007]&[10]&[2]),

ParallelPeriod([Date].[Year-Month-Day].[Day],14, [Order Date].[Year-Month-Day].[Day].&[2007]&[10]&[2])

} ON ROWS,

{} ON COLUMNS

FROM [Adventure Works Cube]

       

Filter([Date].[Year-Month-Day].[Day].Members, [Date].[Year-Month-Day].CurrentMember.Properties('Day of Week') = [Date].[Year-Month-Day].[Day].&[2007]&[10]&[2].Properties('Day of Week'))