MDX-query to get the last Month loaded into a cube

Q: I Need an MDX statement to get the last Month loaded into a cube

A: You can use the ClosingPeriod function. Example:

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

Result:

August 2004
(null)