Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

Need MDX Query to get latest months and previous years same months data, in SSAS

Nice?Vote!

1 Answer

Nice?Vote!
SELECT {ClosingPeriod([Date].[Calendar].[Month], [Date].[Calendar].DefaultMember), ParallelPeriod([Date].[Calendar].[Calendar Year] , 1, ClosingPeriod([Date].[Calendar].[Month], [Date].[Calendar].DefaultMember) ) } ON 0
FROM [Sales Summary];
answered 1 year ago by R (19,530 points)

Related questions