Forum Discussion

Redzero1's avatar
Redzero1
Frequent Visitor
2 years ago

Union Table in M Query

 

Hello,

i have a simple request for M Query experts :

 

I have 3 different Tables ( Table1 , Table2, Table3) with different structure for each of them 

Table1 (Sales , Amount , Date , region , phone) 

Table2 (sales , product, Trade_date, amount , color)

Table3( VAT , amount , sales , client , date , supervisor)

 

what I want to have is One New table with the commun fields Table (Sales, Date , Sales) aggregating all information .

 

I managed to use UNION function in DAX but I want to see if can do it in Power Query using Table.Combine but with selected columns something like the below :

= Table.Combine({#"Table1", #"Table2", #"Table3"}) 

 

thanks for your help 

Need Help

2 Replies

  • Bmejia's avatar
    Bmejia
    Super User
    2 years ago

    Can you just used Merge Queries from the Home tab.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Redzero1 

     

    You can use table.combine to combine. You need to make sure that all three tables have the same columns. In your case you want to create a new table with public fields (probably "Sales", "Amount" and "Date"), so first you need to select and rename the columns in each table to keep the columns Name consistency.

     

    Please try the following:

     

    Edit query per table.

     

    Select and rename columns. Select only the "Sales", "Amount" and "Date" columns. If all column names already meet the requirements, there is no need to rename them.

     

    After all three tables have the same column structure, you can use Table.Combine in a new query. This will create a new table that combines rows from all three tables.

     

    Power Query is case-sensitive, so ensure column names in all tables match exactly. In the Table.Combine function, the column order of all tables should also be the same.

     

    This approach will provide your Power BI model with a new table that summarizes information from three different tables based on the common fields you choose.

     

    m code= Table.Combine({#"Table1", #"Table2", #"Table3"})

     

    Regards,

    Nono Chen

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