LastChild NonEmpty

Question

Hello,

I need to create a calculated measure that the result depend on the level of the time dimension. I always need the Last member of the level Month.

I have i measure that aggregate LastNonEmpty. ([Measures].[LastValue])

I need to create a new measure that changes it value on depends the time level, for example:

For [Time].[Calendar].[Year].&[2009] the value of the new member is ([Time].[Calendar].[Month].&[2009].&[7],[Measures].[LastValue]) -> The last member with value

([Time].[Calendar].[All],[Measures].[LastValue])  -- must be -- > ([Time].[Calendar].[Month].&[200907],[Measures].[LastValue])
([Time].[Calendar].[Year].&[2009],[Measures].[LastValue])  -- must be -- > ([Time].[Calendar].[Month].&[200907],[Measures].[LastValue])
([Time].[Calendar].[Semester].&[H209],[Measures].[LastValue])  -- must be -- > ([Time].[Calendar].[Month].&[200907],[Measures].[LastValue])
([Time].[Calendar].[Trimester].&[T0309],[Measures].[LastValue])  -- must be -- > ([Time].[Calendar].[Month].&[200907],[Measures].[LastValue])

Thanks

Answer 1

Does this blog post help at all?
http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=16

---

http://artisconsulting.com/Blog/GregGalloway