Combining Data in "Address Format"

[Jorr13]

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

[Jorr13]

I'm receiving this Expression Error. Any advise that you can provide @v-yangliu-msft ? 

[v-yangliu-msft · Accepted solution]

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]

@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]

[Jorr13]

Thanks @amitchandak. 

I'm getting this error that it is not recognizing "unichar"

[amitchandak]

@Jorr13 , I have given DAX formula