Forum Discussion
Solved
Combining Data in "Address Format"
I have a number of address columns that need combined. Company Name, Address1, Address2, City, State, Zip, Country etc. How could I combine but in a format on how an address is typically writen ...
Hi Jorr13 ,
Here are the steps you can follow：
1. Create calculated column.
Column = 'Table'[Company Name] & UNICHAR(10) & COMBINEVALUES(",",'Table'[Address1],'Table'[Address2]) & UNICHAR(10) & COMBINEVALUES(",",COMBINEVALUES(",",'Table'[City],'Table'[State]),'Table'[Zip]& UNICHAR(10) & 'Table'[Country])2. Result:
Please click here for the pbix file
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I'm receiving this Expression Error. Any advise that you can provide Anonymous ?