How to Concatonate several columns. - Power BI
community.powerbi.com › t5 › DesktopJul 23, 2020 · 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]...)
CONCATENATE function (DAX) - DAX | Microsoft Learn
learn.microsoft.com › en-us › daxJun 21, 2022 · The CONCATENATE function joins two text strings into one text string. The joined items can be text, numbers, Boolean values represented as text, or a combination of those items. You can also use a column reference if the column contains appropriate values. The CONCATENATE function in DAX accepts only two arguments, whereas the Excel CONCATENATE function accepts up to 255 arguments.