I want to get Latest date in time dimension like example:
I have a [Date] Dimension in
[Adventure Works]. In date Dimension there are: CY 2005, CY 2007,…,CY 2010.
I Want to get latest year “CY 2010” to create some custom calculation member like: current year, current year complete.
Like current year:
sum([Measures].[Internet Sales Amount],[Date].[Calendar].[Calendar Year].&)
or current year complete:
sum([Measures].[Internet Sales Amount],[Date].[Cal
View Complete Post