Append columns from 1 table for using in visual Slicer

[MykytYla]

Dear community I ask your advice.

I have table with two addresses and I want to append these two addresses just for using in the slicer and map. Is it possible? Thank you in advance.

I need Slicer

-LE Code

-LE Name

-Address (Append LE address and Office_adress) (they are different view? but it doesn't matter)

-Country

I have table 

LE Code	LE Name	LE_address	Office_address	Country
QW	Share	build. 1, Little Falls Drive, Wilmington, 19808-1674, USA	Heroiv Dnipra, 4/2	Ukraine
QW	Share	build. 1, University Drive, Newtown, 18940, USA	Zhibek Zholy, 135/10a	USA
TR	Think	build. 5, Degrees North Pilgrim Street, Newcastle, United Kingdom	Soho Limassol, 142nd floor, Anexartisias 187, Limassol 3040	United Kingdom
TR	Think	build. 53, Churchill Place, London, , United Kingdom	11 Chang De Road, 15/F	United Kingdom
VA	Vait	build. 78, 7, Avda. Colón, Córdoba, X5000EPU, Argentina	70 Hindmarsh Square	Argentina
VA	Vait	build. 78, Colón, Córdoba, X5000EPU, Argentina	Serdara Jola Piletica 32	Argentina
OL	Vlog	build. 46, Del IncaEdificio Vitae, Las Condes, 7550000, Chile	110 S Hartford Avenue, Suite 2	Chile
NA	QP	build. 3647, Calle 10 BMadellinEdificio el Atico, Antioquia, Colombia	Huaxia Road, No. 147, Agile	Colombia
LA	Room	build. 15841, University Drive, Newtown, 18940, USA	Padre Mariano 391	USA
LA	Room	build. 121, Concord Pike, Wilmington, 19803, USA	Carrera 43B, 16-95	USA

[MykytYla]

Thank you for help.

I don't need Concat or merge, I need one column with both Addresses. But I don't want to creat table becouce I will not have a primary key

		Address
LA	Room	build. 121, Concord Pike, Wilmington, 19803, USA
LA	Room	build. 15841, University Drive, Newtown, 18940, USA
LA	Room	Carrera 43B, 16-95
LA	Room	Padre Mariano 391
NA	QP	build. 3647, Calle 10 BMadellinEdificio el Atico, Antioquia, Colombia
NA	QP	Huaxia Road, No. 147, Agile
OL	Vlog	110 S Hartford Avenue, Suite 2
OL	Vlog	build. 46, Del IncaEdificio Vitae, Las Condes, 7550000, Chile
QW	Share	build. 1, Little Falls Drive, Wilmington, 19808-1674, USA
QW	Share	build. 1, University Drive, Newtown, 18940, USA
QW	Share	Heroiv Dnipra, 4/2
QW	Share	Zhibek Zholy, 135/10a
TR	Think	11 Chang De Road, 15/F
TR	Think	build. 5, Degrees North Pilgrim Street, Newcastle, United Kingdom
TR	Think	build. 53, Churchill Place, London, , United Kingdom
TR	Think	Soho Limassol, 142nd floor, Anexartisias 187, Limassol 3040
VA	Vait	70 Hindmarsh Square
VA	Vait	build. 78, 7, Avda. Colón, Córdoba, X5000EPU, Argentina
VA	Vait	build. 78, Colón, Córdoba, X5000EPU, Argentina
VA	Vait	Serdara Jola Piletica 32

[Anonymous · Accepted solution]

Hi @MykytYla 

Please try this:

In the Power query, select the LE_address and Office_address column and click the Unpivot Columns in the Transform pane:

Then remove the Attribute column:

Change the name of the values column and the result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @MykytYla 

In Power BI Desktop, go to the 'Home' tab and click on 'Transform data'.

Then click Custom Column in the Add Column tab:

[LE_address]&" "&[Office_address]

The result is as follow:

Hope this can help,

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sahir_Maharaj]

Hello @MykytYla,

Can you please try this approach to create a new calculated column that combines these two columns:

Combined Address = 
IF(
    ISBLANK('YourTable'[Office_address]),
    'YourTable'[LE_address],
    'YourTable'[LE_address] & " | " & 'YourTable'[Office_address]
)

Hope this helps.