Mavericks334
Active Member
- Joined
- Jan 26, 2011
- Messages
- 280
Hi,
I am getting an error while using DATEADD. Below is the error description.
"The Query did not run or the Data Model Could not be accessed. Here is the error message we got:
MDXScript(Model) (6,67) Calculation Error 'Year_Period'[Selected_Moving_Start_Date]: Function 'DATEADD' only works with contiguous date selections."
This the measure that i am using.
Selected_Moving_Start_Date=lastdate(dateadd(Dates[Date_Next_Month_Start],-1,YEAR))
There is a relationship between the date table and year_period table.
Regards,
Ren.
I am getting an error while using DATEADD. Below is the error description.
"The Query did not run or the Data Model Could not be accessed. Here is the error message we got:
MDXScript(Model) (6,67) Calculation Error 'Year_Period'[Selected_Moving_Start_Date]: Function 'DATEADD' only works with contiguous date selections."
This the measure that i am using.
Selected_Moving_Start_Date=lastdate(dateadd(Dates[Date_Next_Month_Start],-1,YEAR))
There is a relationship between the date table and year_period table.
Regards,
Ren.