Union two tables with different columns names in PowerBI

[ayami123]

I have two tables with different names for the columns but with the same meaning and I need to union the two tables to one table with the names of the columns in table A.

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? 


note: this is example is copied,

{

Index

Opening_Date = Business_Date

Store_Name = Location

Store_Number = Location_Code

Table A

Opening_Date                  Store_Name                      Store_Number

1/1/2017                           New York                                  1

Table B

Business_Date                  Location                            Location_Code

2/1/2017                           Boston                                      2

Table C

Opening_Date                  Store_Name                      Store_Number

1/1/2017                           New York                                  1

2/1/2017                           Boston                                      2
}

[v-huizhn-msft · Accepted solution]

Hi @ayami123,

Yes, you can use UNION in Power BI. Please click the "New Table" under Modeling on home page. Please see the button highlighted in yellow background. Then type the formula in the write zone. You will get TableC.

TableC = UNION(TableA,TableB)

Best Regards,
Angelia