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

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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Anonymous , i got if after using the dax in a new table, is it possible to combine them in the same table?

        What i want: am planning to show the hours spent on each project on a particular date, i have 4 columns of project IDs for each person everyday hence i want to combine the IDs into one column.