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

Need Help

Anonymous
4 years ago
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

amitchandak

Super User

4 years ago

Jorr13 , Try to create a column and see if that can work

Add = [Company Name] & unichar(10) & [Address1] & "," & unichar(10) & [Address2] & "," & unichar(10) & "," & [City] & "," & unichar(10) & [State] & "," & unichar(10) & [Zip] & unichar(10) & [Country]