I have a fairly simple calculated measure which does a running sum of a particular measure :
--This does a running sum of the Net Measure up until the previous date (basically a "Starting Count" for a period.
Sum(PeriodsToDate([Change Date].[Year - Month - Date].Levels(0), [Change Date].[Year - Month - Date].PrevMember), [Measures].[Net])
The problem is I have added a second hierarchy in the date dimension that includes quarter called [Year - Quarter - Month - Date].
Is there anyway around not having to create a seperate running sum calculated measure to use this new hierarchy? The PrevMember in the initial calculated measure works, although it reports the wrong number when used in conjunction with the Quarter hierarchy
because it gets the PrevMember in the other hierarchy.
What is the best practice for this situation?Craig
View Complete Post