title: Active Account count on specific date in MDX
body: <p>I have a situation where I need to get active account count on a specific date.</p>
  
  <p>I have start date end date in SQL it looks like </p>
  
  <pre><code>select count(account) where start_date &lt;=@date and end_date &gt;=@date
  </code></pre>
  
  <p>In MDX, I tried below one </p>
  
  <pre><code> AGGREGATE( 
              {
               NULL:LINKMEMBER
                              (
                               [DATE].[YQMWD].CURRENTMEMBER
                               , [StartDate].[YQMWD]
                              )
              }
              * 
              {
               LINKMEMBER
                         (
                          [DATE].[YQMWD].CURRENTMEMBER
                          , [EndDate].[YQMWD]
                         ):NULL
              }
              , ([Measures].[AccountCount])
         )
  </code></pre>
  
  <p>This Code is returning me perfect on date level only  but once I  am traversing to Week or Month it is considering the whole month of the active value. But during the selected month period many account getting deactivate.
   If anybody faced this kind of measure before  like 
  "Active value on specific date" .</p>