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

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]))
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Anonymous , Have you written the union dax formula on "Create a new table using DAX" pane?