title: Power BI create column with condition
body: <p>My direct Query structure img</p>
  
  <p><a href="https://i.stack.imgur.com/o6u2M.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o6u2M.png" alt="enter image description here"></a></p>
  
  <p>I want to create a column in <code>FB_DATA_AD_ONLY</code> to get the <code>VALUE</code> of <code>FB_ACTION_AD</code> where the <code>ACTION_TYPE="something"</code> in power BI. I should keep the function " direct query". Do you think I can do this in Power BI ? </p>