InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:16:33 GMT20http://www.sqlservercentral.com/Forums/Topic1371161-17-1.aspxIs this not working for September Days 1 to 10 or are you looking for an aggregated view of September Days 1 to 10? The query looks like it should work fine for each individual days...MackFri, 12 Oct 2012 08:43:16 GMTMackershttp://www.sqlservercentral.com/Forums/Topic1371161-17-1.aspxWould be nice to have something more re-usable. I found this code with a google search, however is limited when drilling through Transaction Date dim, will not work when Year or Quarter selected. Do I need to create another calculated measure for these?? Seems to clutter up measures group fast and is not flexibleThanks in advance for any help,ChrisThu, 11 Oct 2012 13:01:34 GMTChris Beckerhttp://www.sqlservercentral.com/Forums/Topic1371161-17-1.aspxMy first dive into MDX. I have a calculation which works when 2 entire months are compared. When I filter the Transaction Date to compare e.g. September Days 1 to 10 to October Days 1 to 10, this calc does not work. It still shows a difference in count of 30 days in September (entire month) vs October, so counts are ALL negative. How do I resolve? Tia!! Case// Test for current coordinate being on (All) member.When [Transaction Date].[Date Hierarchy].CurrentMember.Level Is[Transaction Date].[Date Hierarchy].[(All)]Then "NA"// Test to avoid division by zero.When IsEmpty((ParallelPeriod([Transaction Date].[Date Hierarchy].[Month],1,[Transaction Date].[Date Hierarchy].CurrentMember),[Measures].[Checks Count]))Then NullElse (( [Transaction Date].[Date Hierarchy].CurrentMember,[Measures].[Checks Count])-(ParallelPeriod([Transaction Date].[Date Hierarchy].[Month],1,[Transaction Date].[Date Hierarchy].CurrentMember),[Measures].[Checks Count]))EndWed, 10 Oct 2012 17:01:53 GMTChris Becker