Transforming Data based off another Column

[aausten22]

Hi There, 

Not sure if this has already been posted about though cannot find what I am looking for.

Wanting to transform the data where the null turns into text, though I am needing to add the value fo another column in the front of it so instead of being "null" it would become "Column a" + "null transformed".

For example the null will be changed to Director's Office and Column A would be ABC - so it would be transformed to "ABC Director's Office"

Here is the current formula:

= Table.ReplaceValue(#"Changed Type1",null,"Director's Office",Replacer.ReplaceValue,{"Group/Team"})

[aausten22]

Thanks for the reply!

What I'm needing to do is add the value of Column A to the front of "Director's Office"

I have tried using & inbetween them though the error is with Column A as it is a custom column

[amitchandak]

@aausten22 , based on what I got

if you need a new column in the power query

if [Group/Team] = null then "Director's Office" else [Group/Team] 

you can use else if and use Text.Replace as per need