I would like to get the values of the measures of the previous month.
That's what I have:
SELECT [Measures].[Recuent distinct] ON ROWS, TAIL(NonEmptyCrossJoin([Dim Date].[Calendar].[Month Name].Members,1),1) ON COLUMNS FROM [BDID] WHERE [Dim Canal].[Canal].&[Data]
October 2015 Recuent Customers 10344
That's what I would like to have:
September 2015 Recuent Customers 20754
The thing is that my MDX takes the values of the current month, but I want to take the values of the last month. It has to be valid for each month, I mean I would like to have an automatic query for using on Power BI. It means, this month It has to gave me the values of the last month (September) and next month the values of October, in order to avoid the modification of the query each month.
Let me know if you need more information.