title: IIF in With Member comparing dates
body: <p>I am very new to <code>MDX</code> and have a basic question. I would like a calculated measure which returns one value for dates less than a specified date, and another value if greater than a specified date. I have attempted:</p>
  
  <pre><code>with member [measures].[tempmeasure] as 
      IIF
         (
          [Date].[Date].CurrentMember &lt; [Date].[Date].&amp;[20100501]
          , 1
          , 2
         )
  
  select 
     [Date].[Date].Members
     * 
     [measures].[tempmeasure] on columns
  from [MyCube]
  </code></pre>
  
  <p>And this does not seem to work. That is using <code>MS SSAS 2008</code>. 
  Any ideas what I could be doing wrong?</p>