topic Re: Hello, I need help with Dax code to concatenate few columns. in DAX Commands and Tips

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

Vijay_Kumar_P — Fri, 11 Nov 2022 12:39:43 GMT

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.

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

FreemanZ — Fri, 11 Nov 2022 13:00:55 GMT

You can add a new column with the code below:

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

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

ppm1 — Fri, 11 Nov 2022 13:07:57 GMT

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