title: How can I create a new table in Power BI from three columns of another table with a filter?
body: <p>I have a table with repeating values ​​in the index column, and a third column that has values ​​only in some rows</p>
  <p>Table I have now:</p>
  <p><img src="https://i.stack.imgur.com/56ufd.png" alt="Table I have now" /></p>
  <p>My objective is to create a new table that selects the CompanyID, Start Date, and Contact Date columns but excludes the rows that have blank values from any of those</p>
  <p>New table I want to have:</p>
  <p><img src="https://i.stack.imgur.com/NtvYB.png" alt="New table I want to have" /></p>
  <p>I used the following DAX code:</p>
  <pre><code>CALCULATETABLE (
      Table,
      FILTER ( Table, NOT ( ISBLANK ( Table[Start Date] ) ) )
  )
  </code></pre>
  <p>The issue with this code is that it selects all 350+ columns of my original data instead of just having the 3 columns I want. Additionally, I couldn't figure out how to add additional filters so I don't have blank rows for Contact Date and ComapanyID</p>
  <p>I did try the below code as well, but it doesn't work</p>
  <pre><code>CALCULATETABLE (
      Table,
      FILTER ( Table, NOT ( ISBLANK ( Table[Start Date] ) ) ),
      FILTER ( Table, NOT ( ISBLANK ( Table[Order Date] ) ) ),
      FILTER ( Table, NOT ( ISBLANK ( Table[Employee Count] ) ) )
  )
  </code></pre>