I am trying to write a calculated measure formula that
will give me the growth of a measure over the prior time
period but only if that time period exists.

I used */ IIF(IsEmpty([Time].CurrentMember.Lag(1)), NULL,
*/ to try and work around the issue of a non-existent
prior period.


IIF(IsEmpty([Time].CurrentMember.Lag(1)), NULL,
(([Time].CurrentMember, [Measures].[Pct Voluntary
Closure]) - ([Time].CurrentMember.Lag(1), [Measures].[Pct
Voluntary Closure]) ) / ([Time].CurrentMember.Lag(1),
[Measures].[Pct Voluntary Closure]))


Thanks in advance for your help