Forum Discussion
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
Like below:
Bob's Store
24 Winner Street, Apt A
Bozeman, MT 59718
USA
Not like below:
Bob's Store, 24 WInner Street, Apt A Bozeman, MT 59718, USA
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
5 Replies
- amitchandak
Super User
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]
- amitchandak
Jorr13 , I have given DAX formula
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 ?
