How to display multiple column values in one column?

Question

What will be the DAX function to display values from all the columns in one column i.e. &nbsp;col D?&nbsp;Col A &nbsp; &nbsp; &nbsp; Col B &nbsp; &nbsp; &nbsp; Col C &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Col D&nbsp;one &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;two &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;three &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;one two three &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;

eric_zhang · Accepted Answer

n2p2gupta wrote:
What will be the DAX function to display values from all the columns in one column i.e. &nbsp;col D?
&nbsp;
Col A &nbsp; &nbsp; &nbsp; Col B &nbsp; &nbsp; &nbsp; Col C &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Col D
&nbsp;
one &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;two &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;three &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;one two three &nbsp; &nbsp; &nbsp;&nbsp;
&nbsp;
&nbsp;

n2p2gupta
That can be simple. Try&nbsp;
Column D = 'Table'[Column A]&amp;" "&amp;'Table'[Column B]&amp;" "&amp;'Table'[Column C]

Forum Discussion

How to display multiple column values in one column?

2 Replies

Related content

Map displays multiple KPIs

Sequential Order column based on multiple criteria

Multiple line and clustered columns chart

display multiple elements with SELECTEDVALUE

Display the individual multiple measure values under single column