MDX Utility Belt of Calculations Part 2

Devin-Knight, 2009-12-01

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]) 

Rate

Share

Share

Rate

Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis

2009-02-23

1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren

2009-02-17

1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren

2009-02-13

360 reads