SSAS FAQ MDX FAQ MDX-How do you get Last month in the time dimension
MDX-How do you get Last month in the time dimension
User Rating: / 0
PoorBest 
Written by Vidas Matelis   
Tuesday, 27 March 2007 19:17

Q: How do you get Last month in the time dimension

A: You can use function ClosingPeriod( [ Level_Expression [ ,Member_Expression ] ] )

Example (here we assume that default member is [All]):

SELECT ClosingPeriod([Date].[Calendar].[Month], [Date].[Calendar].DefaultMember) ON 0
FROM [Sales Summary]
WHERE ([Measures].[Sales Amount])

Result:

August 2004
(null)

< Prev   Next >
 
Strategy Companion