Forum Discussion
Append columns from 1 table for using in visual Slicer
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 |
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.
4 Replies
- Sahir_Maharaj
Super User
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.
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.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 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.
