topic Re: Append columns from 1 table for using in visual Slicer in DAX Commands and Tips

Append columns from 1 table for using in visual Slicer

MykytYla — Tue, 21 Apr 2026 11:10:24 GMT

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		Ukraine
QW	Share	build. 1, University Drive, Newtown, 18940, USA		USA
TR	Think	build. 5, Degrees North Pilgrim Street, Newcastle, United Kingdom		United Kingdom
TR	Think	build. 53, Churchill Place, London, , United Kingdom		United Kingdom
VA	Vait			Argentina
VA	Vait			Argentina
OL	Vlog			Chile
NA	QP			Colombia
LA	Room			USA
LA	Room			USA

Sahir_Maharaj — Tue, 10 Dec 2024 16:44:28 GMT

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.

Anonymous — Wed, 11 Dec 2024 06:39:47 GMT

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.

MykytYla — Wed, 11 Dec 2024 08:42:57 GMT

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 — Wed, 11 Dec 2024 09:49:47 GMT

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.