2 columns into 1

[YerlaSDU]

Hi Folks,

Could you please help with this issue?

I am trying to create new column which consists 2 existing and getting this error 

[mangaus1111]

I think that you can not combine columns of different tables. Try to have the 2 columns in the same table and then combine

[mangaus1111]

Hi @YerlaSDU ,

try to use the LOOKUPVALUE function using the column [Subclasscode]

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[YerlaSDU]

@mangaus1111 

Not clear, I need to combine 2 columns with "-".

Columnw = LOOKUPVALUE(Classification[Sub-class], 'Characteristics Mapped'[Class], Classification[Sub-class])

it is not working