posted 12/1/2009 8:06:32 PM by DevinKnight
This post is a part of a series of blog posts I am writing to give you a Batman-like Utility Belt of MDX calculations. With this Utility Belt available you can have a template of commonly needed calculations you can use for just about any Analysis Services project.
In part one of this series I showed how you could use the function ParallelPeriod to return sales from the previous year at all levels (Year, Quarter, Month).
In this series I present the business problem, a general solution, and the calculation to solve that problem.
Problem
To show the sales for the previous date member. (Ex. Show the sales for the last year, last quarter, or last month)
Solution
Using a function called PrevMember you can return the value of previous member.
Calculations
The sales for the previous year
([Date].[Year].PrevMember,[Measures].[Sales Amount])
---------------------------------------------------------------
The sales for the previous quarter
([Date].[Quarter].PrevMember,[Measures].[Sales Amount])
The sales for the previous month
([Date].[Month].PrevMember,[Measures].[Sales Amount])
DevinKnight (Member since: 10/27/2009 11:25:07 AM) Devin (MCTS, MCITP) is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin helps run his local users’ group (JSSUG) as a Vice President.
View DevinKnight 's profile
Leave a comment
It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.
enter your email address: