YTD
Hi Mark
You can improve the formula for computing year to date sales even more, if the Time dimension is marked as such. Then you don't need to specify Time.CurrentMember inside YTD, and the formula becomes
Sum(YTD(), Measures.[Units Sold])
Now, if we don't create this as calculated measure, but instead use utility dimension or attribute, which is the best practice for Time related calculations, this could be simplified even more:
Sum(YTD())
Two words instead of seven :)
Mosha.
Biting the hand that feeds IT
