Forum Discussion

melian's avatar
melian
Frequent Visitor
7 years ago
Solved

How to combine three columns into one?

Hi,    I have a table that has three columns (Zip codes columns). I want to combine all of them into one column that has all the zip codes. How can I do that? 
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi melian

Could you please post some sample data to replicate your issue???

 

 

Regards,

Angad

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    CONCATENATE([col1],CONCATENATE([col2],[col3]))

    • melian's avatar
      melian
      Frequent Visitor
      7 years ago

      Anonymous

      The problem with this is that it combines them on the same line, which is not what I want. Your code would make the the new list looks like this 

       

       

       

       

      However, I want the new list to look like this 

  • melian's avatar
    melian
    Frequent Visitor
    7 years ago

     

    This is an example of what I want to do. In the table I am working on there are three columns, the first three, of zipcodes. I want to combine all of them into one column, All ZipCodes. 

    Anonymous

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      melian,

       

      You may select Unpivot Columns in the Query Editor or use UNION Function in DAX.

      • melian's avatar
        melian
        Frequent Visitor
        7 years ago

        v-chuncz-msft Thank you so much. The UNION function did the job. Much appreciated. 

    • rkumar's avatar
      rkumar
      Icon for Helper III rankHelper III
      6 years ago

      Hi Melian, Can you please post your solution DAX . I have the same requirement but UNIOn is not working in my case.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      Use Summarize with union function as shown below-

       

      AllZipCode =
      UNION(SUMMARIZE('Table','Table'[ZipCode1]),SUMMARIZE('Table','Table'[ZipCode2]),SUMMARIZE('Table','Table'[ZipCode3]))
       
      Angad
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        @AngadK , i have a similar requirement, tried the union dax with Summarize its throwing an error, can you please help me with this

         
         
        Project IDs = UNION(SUMMARIZE('Table','Table'[Project_ID1]),SUMMARIZE('Table','Table'[Project_ID2]),SUMMARIZE('Table','Table'[Project_ID3]),SUMMARIZE('Table','Table'[Project_ID4]))