Forum Discussion

YerlaSDU's avatar
YerlaSDU
Helper I
3 years ago

2 columns into 1

Hi Folks,

 

Could you please help with this issue?

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

 

Need Help

3 Replies

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    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's avatar
      YerlaSDU
      Helper I
      3 years ago

      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

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

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