Concatenate Text Columns into a Single Column

[Mbstrand]

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

      Column_SalesRep3

I have tried several approaches, created a new Table with just the fields I want to search against, but the Slicer isn't working. 

Thanks for any suggestions!

[mahoneypat · Accepted solution]

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]

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]

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).

[Mbstrand]

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.  ???