topic Re: How to display multiple column values in one column? in Developer

How to display multiple column values in one column?

n2p2gupta — Wed, 14 Jun 2017 22:49:25 GMT

What will be the DAX function to display values from all the columns in one column i.e. col D?

Col A Col B Col C Col D

one two three one two three

Re: How to display multiple column values in one column?

Eric_Zhang — Fri, 16 Jun 2017 02:43:38 GMT

@n2p2gupta wrote:

What will be the DAX function to display values from all the columns in one column i.e. col D?

Col A Col B Col C Col D

one two three one two three

@n2p2gupta

That can be simple. Try

Column D = 'Table'[Column A]&" "&'Table'[Column B]&" "&'Table'[Column C]

Re: How to display multiple column values in one column?

n2p2gupta — Mon, 19 Jun 2017 17:05:58 GMT

Thanks. Also concatentated function also worked:

Column4 = CONCATENATE(CONCATENATE(CONCATENATE(Format(table[column].[Date],"dddd"), " "), CONCATENATE(table
[column2]," ")), table[column3])