How to get the measure for the last day in a month in DeepSee
Hi, Community!
How can I manage to show in MDX query months where every month shows the value of the last month?
Say, in HoleFoods the query:
SELECT NON EMPTY [Measures].[Amount Sold] ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HOLEFOODS]
will show me the sum of revenue per month.
This query:
SELECT NON EMPTY [Measures].[Amount Sold].MAX ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HOLEFOODS]
will show the Max revenue in a day for the given month.
But what MDX will show the months with the revenue for the last day in a month?