<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">I've solved that using the undocumented LastNonEmpty function. The formula, in your case, would look something like:<div class=""><br class=""></div><div class=""><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>([Measures].[SEMIADD_MEASURE], LastNonEmpty(Descendants([Time].CurrentMember), [Measures].[SEMIADD_MEASURE]))</div></div><div class=""><br class=""></div><div class="">Hope this helps,</div><div class=""><br class=""></div><div class="">--</div><div class="">Manuel Aristarán</div><div class=""><a href="http://jazzido.com" class="">http://jazzido.com</a></div><div class=""><br class=""></div><div class=""><br class=""></div></body></html>