Reply
Regular Visitor
Posts: 17
Registered: ‎07-04-2017

Re: Union two tables with different columns names

I want to use union because I'm not allow to edit and create new excel file.  =_=
that's why i want to use union
is there anyway I can use Union in PowerBI? 

Highlighted
Frequent Visitor
Posts: 3
Registered: ‎01-04-2018

Re: Union two tables with different columns names

The solution for your problem can be released by using Union and Selectcolumns Function: 

 

Union(
selectcolumns(Table A,"Opening_Date", Table A[Opening_Date], "Store_Name", Table A[Store_Name],"Store_Number", Table A[Store_Number]),
selectcolumns(Table B,"Business_Date", Table B[Business_Date], "Location", Table B[Location],"Location_Code", Table B[Location_Code])
)

You should try this way.

 

Good luck! Smiley Happy

Visitor
Posts: 1
Registered: ‎11-28-2018

Re: Union two tables with different columns names

Hi @Ohad

 

The simplest way I found was to use the DAX - Union (Selectcolumns(), Selectcolumns())

 

Here you can select the tables, individual columns as well as rename those columns on the fly for the Union funciton to combine the dataset together.

 

Cheers,

M