How can I write an MDX query to get Patient Count measure aggregation for last 36 month from Year End.
I am using SSAS on SQL Server 2014. My cube is named BR. I have a Patient Count Dimension and Accounting Date dimension. Accounting Date has members year, month, quarter and properties Current Period and Year End Period.
CREATE MEMBER CURRENTCUBE.[Measures].[Year End Period]
AS [Accounting Date].[Accounting Date].Properties( "Year End Period" ),
VISIBLE = 1;
Following query gives DEC - 2017.
SELECT NON EMPTY { [Measures].[Year End Period] } ON COLUMNS FROM [BR]
How can I utilize this to get patient count for last 36 months from this period?
Thanks in advance for you help.