I have a measure
SUM(LastPeriods (29, [Date].[Month].CurrentMember), ([Measures].[TotalStake] - [Measures].[CreditsStake]))
This performs well when you drilldown to the Date level, however when viewing at the month level it SUMs over the last 29 MONTHS. Now I understand why this happens but I would like it to SUM the last 29 Days from the last day of the month when being viewed
at the MONTH level of the hierarchy, as weel as last 29 days from DATE when being viewed at the date level. Is this possible?
Thanks in advance
View Complete Post