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