Use Custom Colum in power editor with merge Column

[Anonymous]

Hi I.m using if condition in Data views instead of power editor.

So the column "Final plant code" is not shown in the power editor MB52 Table.

So now, can anyone change this formula as a Dax query, so I directly use this in the custom column in Power editor. 
In the final view, I use this because I want to use a merge table (i have merge 3 tables with 3 columns) but in this for one column is not shown in power editor so how I use the merge function. 

I use this code but Show an error

[mahoneypat]

else is misspelled on the first line of your formula

Regards,

Pat

[Anonymous]

ohh!! it's by mistake, still unable to load.