Forum Discussion

bmarcowka's avatar
bmarcowka
Helper I
6 years ago
Solved

Address Block

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

 

Needed format

 

CustName

CustAddress1

CustAddress2

CustCity, CustSt CustZip

 

Any guidance is appreciated. 

Need Help
  • MartynRamsden's avatar
    MartynRamsden
    6 years ago

    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.

5 Replies

  • MartynRamsden's avatar
    MartynRamsden
    Solution Sage
    6 years ago

    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's avatar
      bmarcowka
      Helper I
      6 years ago

      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