Forum Discussion
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?
@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 , Have you written the union dax formula on "Create a new table using DAX" pane?
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.