Address Block

[bmarcowka]

I have a need to present on a screen an address block. 

Needed format

CustName

CustAddress1

CustAddress2

CustCity, CustSt CustZip

Any guidance is appreciated. 

[MartynRamsden · Accepted solution]

Hi @bmarcowka 

You could use the expression below to create a column in your table:

Address Block = 
VAR Name = Table1[CustName]
VAR Add1 = Table1[CustAddress1]
VAR Add2 = Table1[CustAddress2]
VAR City = Table1[CustCity]
VAR Zip = Table[CustZip]
VAR Result = 
Name & UNICHAR(10) & Add1 UNICHAR(10) & Add2 UNICHAR(10) & City & ", " & Zip
RETURN Result

If you need it as a measure, use this instead:

Address Block = 
VAR Name = SELECTEDVALUE( Table1[CustName] )
VAR Add1 = SELECTEDVALUE( Table1[CustAddress1] )
VAR Add2 = SELECTEDVALUE( Table1[CustAddress2] )
VAR City = SELECTEDVALUE( Table1[CustCity] )
VAR Zip = SELECTEDVALUE( Table[CustZip] )
VAR Result = 
Name & UNICHAR(10) & Add1 UNICHAR(10) & Add2 UNICHAR(10) & City & ", " & Zip
RETURN Result

Best regards,
Martyn

If I answered your question, please help others by accepting it as a solution.

[bmarcowka]

Thank you @MartynRamsden. Getting message The sysntax for UNICHAR is incorrect.  

Address Block =

VAR CustName = OrgStops[CustName]

VAR Add1 = OrgStops[CustAddress]

VAR City = OrgStops[CustCity]

VAR State = OrgStops[CustState]VAR Zip = OrgStops[CustZip]

VAR Result =

CustName & UNICHAR(10) & Add1 UNICHAR(10) & City & ", " & Zip

RETURN Result

[MartynRamsden]

Hi @bmarcowka

You're missing an ampersand '&' between Add1 and UNICHAR(10)

Best regards,
Martyn

[MartynRamsden]

Sorry @bmarcowka

Just realised it was missing from my original example. Apologies!

[bmarcowka]

Worked perfectly.  Now to get it to be left justified.  

Thanks again @MartynRamsden