Forum Discussion

melian's avatar
melian
Frequent Visitor
8 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
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

melian,

 

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

melian's avatar
melian
Frequent Visitor
8 years ago

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