How to merge 2 or more columns into one?

[Pooja_Mishra]

I want to merge all these columns as shown in Table 1 to get a new column as 'Result Column'

Table 1:

Column 1	Column 2	Column 3	Column 4	Column 5
ABC	DEF		DEF
DEF		ABC		MNO
GHI	ABC	DEF	JKL
JKL		GHI		PQR

Result Column

ABC,DEF,DEF

DEF,ABC,MNO

GHI,ABC,DEF,JKL

JKL,GHI,PQR

[v-luwang-msft]

Hi @Pooja_Mishra ,

Based on your table,do like this:

Result =
VAR TEST1 =
    IF (
        'Application Catalogue_DAU'[Business Division_1] = BLANK (),
        'Application Catalogue_DAU'[Business Division],
        'Application Catalogue_DAU'[Business Division] & "," & 'Application Catalogue_DAU'[Business Division_1]
    )
VAR test2 =
    IF (
        'Application Catalogue_DAU'[Business Division_4] = BLANK (),
        test1,
        test1 & "," & 'Application Catalogue_DAU'[Business Division_4]
    )
VAR test3 =
    IF (
        'Application Catalogue_DAU'[Business Division_7] = BLANK (),
        test2,
        test2 & "," & 'Application Catalogue_DAU'[Business Division_7]
    )
RETURN
    test3

Return the last "test"

Best Regards

Lucien

[v-luwang-msft · Accepted solution]

Hi @Pooja_Mishra  ，

You can use the following dax to create a new column:

Result Column =
VAR TEST1 =
    IF (
        'Table'[Column 2] = BLANK (),
        'Table'[Column 1],
        'Table'[Column 1] & "," & 'Table'[Column 2]
    )
VAR test2 =
    IF ( 'Table'[Column 3] = BLANK (), test1, test1 & "," & 'Table'[Column 3] )
VAR test3 =
    IF ( 'Table'[Column 4] = BLANK (), test2, test2 & "," & 'Table'[Column 4] )
VAR test4 =
    IF ( 'Table'[Column 5] = BLANK (), test3, test3 & "," & 'Table'[Column 5] )
RETURN
    test4

And final you will get like below:

Wish it is helpful for you !

Best Regards

Lucien 

[amitchandak]

@Pooja_Mishra , Try like this as new column in dax

[Column 1] & if(not(isblank([Column 2])),", " [Column 2], "") & if(not(isblank([Column 3])),", " [Column3], "") & if(not(isblank([Column 4])),", " [Column 4], "") & if(not(isblank([Column 4])),", " [Column 4], "")

[Pooja_Mishra]

Thanks for your response. I tried it but did not work