title: Combine PowerBI DAX Filter and SELECTCOLUMN
body: <p>I want to create a new table based on this one: 
  <img src="https://i.stack.imgur.com/1Tp1h.png" alt="This is my initial table"></p>
  
  <p>that filters for Warehouse=2 and "drops" the columns "Price" and "Cost" like this:</p>
  
  <p><img src="https://i.stack.imgur.com/Xk01W.png" alt="This is what I want to have"></p>
  
  <p>I have managed to apply the filter in the first step using:</p>
  
  <p><code>FILTER(oldtable;oldtable[Warehouse]=2)</code></p>
  
  <p>and then in the next step cold create another table that only selects the required columns using:</p>
  
  <p><code>newtable2=SELECTCOLUMNS("newtable1";"Articlename";...)</code></p>
  
  <p>But I want to be able to combine these two functions and create the table straight away.</p>