locked
How to Create Previous Month MDX measures RRS feed

  • Question

  • I have Date dimension with following hierarchy 
    Year>Quarters>Month>Date
    I have measure IDCOUNT in a fact table on daily basis.
    Now I want to create following MDX measures. 

    Previous Month IDCount 
    Previous Month IDCount-1  -- means 1 month from previous Lag(1) on monthly basis
     
    If a user select month [Jan 2015] then MDX measures should be 

    Previous Month IDCount    -- [Feb 2015]
    Previous Month IDCount-1  -- [Dec 2014] 
    Monday, March 16, 2015 3:05 PM

Answers

All replies