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 sim...
- 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. 🙂
LeandroCampacci
Helper I
Helper IThe 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. 🙂