How to create a conditional column based on newly added column in data?

Question

Hi,&nbsp;I have parsed out text from a column (Team)and created&nbsp; a new one (Team ver1). I would like to rename some values in Team ver1 column but Power BI won't allow me to do that using conditional column as it picks only original columns from the data.&nbsp;&nbsp;Is there a way to achieve this?&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;saipawar&nbsp;&nbsp; I assume you are creating a conditional column teamver1 and you would like to replace some values. You can use the "add conditional Column" in power Query and handle the replacement by using the IF clause .&nbsp;&nbsp;If this is not you are looking for, then more details is appriciated.&nbsp;ThanksRaj&nbsp;

saipawar · Answer

Hi&nbsp;Anonymous&nbsp;I am aware of this functionality. However, the column I intend to use is a derived column. It did not exist in the original table.&nbsp;&nbsp;&nbsp;

alexisolson · Answer

If you defined the derived column outside of the query editor (presumably with DAX), then you'll need to define your conditional column with DAX as well. You can't bring a DAX calculated column back into the query editor.

v-jingzhang · Answer

Hi&nbsp;saipawar&nbsp;
&nbsp;
Where is the&nbsp;derived column located in? When it's a column in another query, there are methods like merging queries or adding a custom column with some M code to bring data from another query. For example:&nbsp;Power Query new custom column from another table - Microsoft Q&amp;A
&nbsp;
If it's a calculated column in the model, then we need to consider other methods.&nbsp;
&nbsp;
Please share some sample data &amp; expected result as well as the logic for conditions so that we can give some detailed suggestions.&nbsp;
&nbsp;
Best Regards, Community Support Team _ JingIf this post helps, please Accept it as Solution to help other members find it.

Forum Discussion

How to create a conditional column based on newly added column in data?

4 Replies

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