title: Condition with multiple columns in DAX
body: <p>can I somehow filter in DAX with multiple columns?</p>
  
  <p>I need filter that the difference between two dates are lower than 300 days like below.</p>
  
  <pre><code>EVALUATE
  (
      CALCULATETABLE
      (
          SUMMARIZE
          (
              'Sales',
              'Sales'[MaxDatum],
              'Sales'[MinDatum]
          ),
          INT('Sales'[MaxDatum] - 'Sales'[MinDatum]) &lt; 300            
      )
  )
  </code></pre>
  
  <p>So it failed with this error:</p>
  
  <blockquote>
    <p>The expression contains multiple columns, but only a single column can
    be used in a True/False expression that is used as a table filter
    expression.</p>
  </blockquote>
  
  <p>I tried another construction of that query like this, but in this case I cannot reuse the calculated member.</p>
  
  <pre><code>EVALUATE
  (
      CALCULATETABLE
      (
          SUMMARIZE
          (
              'Sales',
              'Sales'[MaxDatum],
              'Sales'[MinDatum],
              "DIFF", INT('Sales'[MinDatum] - 'Sales'[MaxDatum]) 
          ),
          [DIFF] &lt; 300        
      )
  )
  </code></pre>
  
  <p>Is possible to do this somehow in DAX query?</p>
  
  <p>Thanks for your help</p>