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

[saipawar]

Hi,

I have parsed out text from a column (Team)and created  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. 

Is there a way to achieve this?

[Anonymous]

Hi @saipawar 

  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 . 

If this is not you are looking for, then more details is appriciated.

Thanks

Raj

[saipawar]

Hi @Anonymous 

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. 

[v-jingzhang]

Hi @saipawar 

Where is the 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: Power Query new custom column from another table - Microsoft Q&A

If it's a calculated column in the model, then we need to consider other methods. 

Please share some sample data & expected result as well as the logic for conditions so that we can give some detailed suggestions. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[AlexisOlson]

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.