Forum Discussion

Mbstrand's avatar
Mbstrand
Frequent Visitor
5 years ago
Solved

Concatenate Text Columns into a Single Column

I am trying to combine 3 text columns into a single, "master" column that can more easily be used for search.    Example:   Table_Contacts       Column_SalesRep1       Column_SalesRep2       C...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You could unpivot the 3 columns and get all the values in one column that you could use in the slicer and/or the search column.  If you can't do that, you can use SELECTCOLUMNS and UNION to combine the 3 columns into a single column of distinct values.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Why not just concatenate the columns in the query editor (or with a DAX column)?  A custom column in query with 

= [Column_SalesRep1] & " " & [Column_SalesRep2] & " " & [Column_SalesRep3]

 

Regards,

Pat

  • Mbstrand's avatar
    Mbstrand
    Frequent Visitor
    5 years ago

    Thanks Pat for the suggestion!   I did try this, but it's combining the Sales Rep names by Account in a single cell.  I'd like one Sales Rep per cell.  ???

  • Mbstrand's avatar
    Mbstrand
    Frequent Visitor
    5 years ago

    Hi Pat, so this solution DOES work for search.   (Thanks!)    Now, I'd like to use a Slicer where all of the Sales Reps are listed in the drop down (not combined).