Replace values in one column with a conditional referencing another column

[nheller]

I have two columns: 'Partner Name' and 'Client Name'. Each time a particular value in 'Partner Name' is referenced ('xyz'), I'd like to replace the corresponding null in 'Client Name' with a new value ('abc'). I'm new to Power BI and haven't quite picked up on M yet-- Can somebody help me out?

[v-yulgu-msft · Accepted solution]

Hi @nheller,

You could create a new 'Client Name' column, then, remove the original one.

Best regards,

Yuliana Gu

[Anonymous]

@v-yulgu-msft 

What should be written under "Else" if I wish the values to remain the same, if the specified conditions above are not met?

thank you!