Home Forums Data Warehousing Analysis Services Last Year using Scope or Calculated Member - Rollup issue or Grand Total issue RE: Last Year using Scope or Calculated Member - Rollup issue or Grand Total issue

  • July 4, 2014 at 8:49 am

    #1727103

    I can't see the picture....

    But why aren't you using PARALLELPERIOD instead of your cousin>ancestor.lag(1) thing above? It's simpler....

    [Code="Other"]

    SUM(

    PARALLELPERIOD

    ([Time].[Year - Quarter - Month - Date].[Year],

    1 ,

    [Time].[Year - Quarter - Month - Date].CurrentMember),

    [Measures].[Sales Discount])

    [/Code]

    🙂

    I'm on LinkedIn