Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Concatonate several columns.

Hello,   I want to create a new colomn that concatonates three colomns into one key.  eg. I want Month, name and vrg to be in a field beside this that says JAN5 GUYS CSD 500ml PET.  What is the sim...
Need Help
LeandroCampacci's avatar
LeandroCampacci
Icon for Helper I rankHelper I
6 years ago

The best way for this, is using Power Query (select columns -> tab Add Column -> Merge OR select columns, right click on then and "merge").

 

Also, if you want to do this on a calculated column (less performance), create a new column using DAX expression CONCATENATE. 

 
Your Column = CONCATENATE('Table'[Column 1], 'Table'[Column 2]...)
 
Remember: Power Query is the recomended away to do this. 🙂