Power BI create column with condition direct query

Question

&nbsp;&nbsp;I want to create a column in FB_DATA_AD_ONLY to get the VALUE of FB_ACTION_AD where the ACTION_TYPE="something" in power BI. I should keep the function " direct query". Do you think I can do this in Power BI ?&nbsp;

eric_zhang · Accepted Answer

dsyouness
Creating calculated column is not supported in DirectQuery mode, you can create the "calculated column" in SQL if the data source is a database, otherwise you may have to switch to Import mode.

Forum Discussion

Power BI create column with condition direct query

1 Reply

Related content

Create measure to return value from column when condition met for two other columns

Create conditional index column

Create columns group

Conditional Column with Multiple Conditions

Create Conditional Column Based Upon Two Other Columns