Hello, I need help with Dax code to concatenate few columns.

[Vijay_Kumar_P]

Sample data:

For example, I want to concatenate C1,C2,C3,C4 columns and I don't want to include Null values in the Output Column. 

Thanks in advance.

[ppm1 · Accepted solution]

I would do that kind of thing in the query editor, but here is a DAX column expression you can use. A virtual table is created with { }, filtered to remove blanks, and then the results are concatenated with no delimiter. Replace T1 with your actual table name.

Concat =
VAR ValuesAsTable =
    FILTER ( { T1[C1], T1[C2], T1[C3], T1[C4] }, [Value] <> "" )
RETURN
    CONCATENATEX ( ValuesAsTable, [Value], "" )

Pat

[FreemanZ]

You can add a new column with the code below:

Expected Output = Data[C1]&Data[C2]&Data[C3]&Data[C4]