title: Ignore repeated days values using MDX
body: <p>How can i ignore repeated days values using MDX ?</p>
  
  <p>For example, from this:</p>
  
  <ul>
  <li>12/1/1997</li>
  <li>12/2/1997</li>
  <li>12/3/1998</li>
  <li>12/4/1999</li>
  </ul>
  
  <p>To this:</p>
  
  <ul>
  <li>12</li>
  </ul>
  
  <p>I'm already tried use Distinct, but i'ts like they still considere as unique dates.</p>
  
  <pre><code>SELECT 
    {} ON COLUMNS,
    DISTINCT([Time].[Weekly].[Day].Members) ON ROWS FROM [Sales 2]
  </code></pre>