title: SUMMARIZECOLUMNS to return results for all future dates
body: <p>How to use SUMMARIZECOLUMNS and retain results for all values of specific column Date[Date] (Calendar)?</p>
  <pre><code>EVALUATE
  SUMMARIZECOLUMNS (
      'Date'[Date],
      'Sales'[CustomerKey],
      &quot;__MaxDate_Sales&quot;,
          CALCULATE (
              MAX ( 'Sales'[Order Date] )
              ,REMOVEFILTERS ( 'Sales' ) 
              ,VALUES ( Sales[CustomerKey] ) --Comment this line to get full Calendar dates
          )
  )
  ORDER BY 'Date'[Date] DESC
  </code></pre>
  <p>Link to the playground to replicate the problem:</p>
  <p><a href="https://dax.do/JQ83Voo6Ds93B1/" rel="nofollow noreferrer">https://dax.do/JQ83Voo6Ds93B1/</a></p>
  <p>Commenting the line <code>,VALUES ( Sales[CustomerKey] )</code> results in getting all 'Date'[Date] until 2011-12-31 (as desired), however, the function does not return the last date distinct for each Customer. Uncommenting it, returns correct results but shrinks the Date table to the max of Sales table date.</p>
  <p>Is it possible to resolve the problem without wrapping SUMMARIZECOLUMNS with ADDMISSINGITEMS?</p>
  <pre><code>+------------+--------------------+-----------------+-----------------+
  | Date[Date] | Sales[CustomerKey] | __MaxDate_Sales |     Status      |
  +------------+--------------------+-----------------+-----------------+
  | 2011-12-31 |                123 | 2009-12-31      | Current result  |
  | 2011-12-31 |                123 | 2007-01-02      | Expected result |
  | 2011-12-31 |                998 | 2007-08-31      | Expected result |
  +------------+--------------------+-----------------+-----------------+
  </code></pre>
  <p>If you comment the line above, then the current result is the same for any client. The Date table is 2 years longer than the Sales table.</p>