How to display multiple column values in one column?

[n2p2gupta]

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       

[Eric_Zhang · Accepted solution]

---

@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]

[n2p2gupta]

Thanks.  Also concatentated function also worked:

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