Hi,
I am new here and pretty new to mdx and I am trying to make my first mdx report.
So here it is my question (or the first one for now )
I have a mdx query that returns the data from yesterday on the first column.
How do I do to give me the data from the day before yesterday in the second column, the avg for this month calculating the amount of days of the month till today on the third column and on the fourth the avg of last month, calculating the avg days of last month.
I don’t need everything, but I need to be pointed in the correct direction, which apparently I miss the turn .
Here is the code.

with

member [Measures].[Max] As
max({[Hour Dim].[D Hour].[All].children},[Measures].[Purchase - converted to USD])

member [Measures].[Min] As
min({[Hour Dim].[D Hour].[All].children},[Measures].[Purchase - converted to USD])

member [Measures].[Avg] As
avg({[Hour Dim].[D Hour].[All].children},[Measures].[Purchase - converted to USD])



select strToMember("[Time].[Year - Month - Period - Date].[Date].&[" + Format(dateadd("d",now(),-1), "yyyy-MM-ddT00:00:00") +"]") on columns,
{[Measures].[Purchase - converted to USD],
[Measures].[Purchases_Count],
[Measures].[Site Pay User],
[Measures].[Free_signups],
[Measures].[free to site pay user],
[Measures].[click to site pay user],
[Measures].[Click Count],
[Measures].[Guests Logins Count],
[Measures].[Guests Unique Logged in],
[Measures].[Guests Credit Spent],
[Measures].[Max],
[Measures].[Min],
[Measures].[Avg]} on rows

thanks!!