Forum Discussion

n2p2gupta's avatar
n2p2gupta
Frequent Visitor
9 years ago
Solved

How to display multiple column values in one column?

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             ...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago
    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]
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago
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's avatar
n2p2gupta
Frequent Visitor
9 years ago

Thanks.  Also concatentated function also worked:

 

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