title: Get last time within each member of a dimension has data
body: <p>In a cube, There is a time [DimDate].[Date] and location [DimLocation].[State] dimension. I want to find out what is the last date for each state in which that state has data (is not empty).</p>