How do I calculate sales for 12 Month to date in MDX, in SSAS?

Nice?Vote!

asked 1 year ago in SSAS Interview Questions and Answers by R (19,530 points)

1 Answer

Nice?Vote!

WITH MEMBER [Measures].[Last 12 Mth Order Count] AS SUM( ClosingPeriod([Date].[Calendar].[Month], [Date].[Calendar].[All Periods]).Lag(12): ClosingPeriod([Date].[Calendar].[Month], [Date].[Calendar].[All Periods]), [Measures].[Order Count])SELECT [Measures].[Last 12 Mth Order Count] ON 0
FROM [Adventure Works]

answered 1 year ago by R (19,530 points)

Related questions

Nice?Vote!

1 answer

I need an MDX statement to get the first month of the last year loaded into a cube, in SSAS

asked 1 year ago in SSAS Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

I need an MDX statement to get the last Month loaded into a cube, in SSAS

asked 1 year ago in SSAS Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

I need an MDX statement to show the first day of the last month in the cube, in SSAS

asked 1 year ago in SSAS Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

MDX query to show year level data for all years except the last one, and month level data for the last year, in SSAS

asked 1 year ago in SSAS Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

How do you get Last month in the time dimension, SSAS MDX function

asked 1 year ago in SSAS Interview Questions and Answers by R (19,530 points)