Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

MDX Utility Belt of Calculations Part 2

  • 1 December 2009
  • Author: DevinKnight
  • Number of views: 6193
  • 0 Comments

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

 

Print
Tags:
Rate this article:
5.0
DevinKnight

DevinKnightDevinKnight

Other posts by DevinKnight

Please login or register to post comments.