title: how to get min or max date on columns in mdx query
body: <p>what mdx query logic could i implement for this example to get two rows in result set for hrid = 1 with 1/1/16 as min date(start) for first row where someattribut shows up on column with value 'A'
  and 1/15/16 as min date(start) for second row where someattribute has value of 'B' and measure.whatevers has its aggregation for whatever data corresponds to that dimension row.</p>
  
  <p>Im trying to just look at january 2016 </p>
  
  <p>everything ive tried i seem to get min date values of 1/1/1900 or both rows have value of 1/1/2016 or i get errors since i cant figure it out.</p>
  
  <p><a href="https://i.stack.imgur.com/DcCdg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DcCdg.png" alt="enter image description here"></a></p>
  
  <p>heres my mdx sample:</p>
  
  <pre><code>WITH MEMBER [Measures].[Start] as 
    (
  -- min date that the combination of someattribute and hrid have certain 
  -- value withing the range of the where clause restriction of january 2016
  
  SELECT { 
  [Measures].[Start]
  , [Measures].[Whatevers]
  } ON COLUMNS
  , NON EMPTY { 
  [Agent].[HRID].children
  * [Agent].[someAtribute].Members
  } ON ROWS
  FROM [RADM_REPORTING]
  WHERE ( 
      [Date].[Date View].[Month].&amp;[201601]
      )
  </code></pre>