Hi all,

I'm trying to calculate a measure that will provide the value for the last
day in any given period, at any level. So looking at the year level (with
this year's data), you see the value for yesterday; and you should get the
same value if you are looking at the current quarter/month/week and day.

I have been looking at ClosingPeriod() is it sounds like it should give me
what I want, but it only seems to return calculations at one particularlevel
- i.e. if I change the view and go "up" the time dimension, the cells are no
longer calculated.

My measure calculation is as follows:

WITH MEMBER [Measures].[CALC_THING] AS
'([Measures].[BASE_THING],
ClosingPeriod([Trading Date].[Day],
[Trading Date].CurrentMember))'

Can anyone provide the required "nudge", as I feel I'm losing a grip on how
this stuff works!

Many thanks,


Peter