Home Forums Article Discussions Article Discussions by Author Discuss content posted by ANDREW.MUYOBO Creating Custom Calendars in SQL Server Analysis Services RE: Creating Custom Calendars in SQL Server Analysis Services
ANDREW.MUYOBO
SSC Enthusiast
Points: 190
More actions
September 29, 2010 at 7:46 am
#1229016
Using MDX with Custom Calendars is tricky - basically you have to avoid using MDX fuctions and simply write the code to lag back by the number of days or weeks to get the correct matching - MDX has a LAG function that you can use.:-P