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
jakobob's avatar
jakobob
New Member
3 years ago

Hey!
There's no build in function in Power BI for that, but you can use M/Power query. 

(Source) =>
    let
        result = Table.FromList(List.Combine(Table.ToColumns(Source)), null, {"AllZipCodes"})
    in
        result

 Just google for how to apply Power Query to your Power BI. 
However this function replaces all your columns. If you want to keept the old columns you got to customize the function. 

Cheers Jakobob