Home/ Questions/Q 462
Next
In Process
frankline98blue
  • 5
Beginner
Asked: 2023-06-07T04:08:35+00:00 In:

How to combine multiple tables in Power BI?

  • 5

In Power BI, how do you join numerous tables into a single table? I have more than two tables and would like to combine them into a single table.

Data EngineeringPower Bi
Share
Leave an answer

Leave an answer

Browse

1 Answer

  1. Pundit

    You can combine the three tables into a single new table by this method.

    1. Combine TABLE ONE and TABLE TWO.  ====> NEW TABLE [columns – TABLE TWO, Name] 
    2. Choose all columns from TABLE ONE.  In the NEW TABLE, choose the first and last columns of TABLE TWO.
    3. Combine TABLE THREE and NEW TABLE  ======>   TABLE REPLACEMENT.     [columns – TABLE THREE, Name]
    4. Choose only the first column of TABLE ONE and the last columns from TABLE TWO and TABLE THREE.
    5. You will obtain the result you want.
    • 1