Forum Discussion
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 simpletst way to do that?
| Months | NAME | VRG | Months Order |
| JAN | 5 GUYS | CSD 500ml PET | M01 JAN |
| JAN | 5 GUYS | DAS 591ml | M01 JAN |
| JAN | 5 GUYS | NT 500ml | M01 JAN |
| JAN | 5 GUYS | Postmix Jc BIB 10L | M01 JAN |
| JAN | 5 GUYS | Postmix Jc BIB 20L | M01 JAN |
| JAN | 5 GUYS | Postmix Spk BIB 10L | M01 JAN |
| JAN | 5 GUYS | Postmix Spk BIB 20L | M01 JAN |
- I would recommend using Power Query to do this. Select each column in order you want them concatenated, then click Merge columns on the Add Column tab in Power Query Editor.
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. 🙂
2 Replies
- AllisonKennedy
Community Champion
I would recommend using Power Query to do this. Select each column in order you want them concatenated, then click Merge columns on the Add Column tab in Power Query Editor. 
LeandroCampacciHelper I
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. 🙂