Forum Discussion
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
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!
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
4 Replies
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
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. ???
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).
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
